Allow using a different query for counting

Created on 5 April 2023, over 2 years ago

Fetching every result and counting them in CustomSQLQuery::count() can be quite slow for large queries.

We could add a sql_count_query option with a different query.
It would allow us to do something like this:

sql_count_query: 'SELECT COUNT(*) FROM foo' # COUNT(*) is usually pretty fast
sql_query: 'SELECT * FROM foo' # Slow query with a lot of results

✨ Feature request

Status

Active

Version

1.3

Component

Code

Created by

🇫🇷France prudloff Lille

Live updates comments and jobs are added and updated live.

Merge Requests

prudloff → committed fa0f01e9 on 8.x-1.x

Issue #3352320 by prudloff: Allow using a different query for counting

Production build 0.71.5 2024