- Issue created by @prudloff
- @prudloff opened merge request.
- Status changed to Needs review
over 1 year ago 8:18am 5 April 2023
Fetching every result and counting them in CustomSQLQuery::count()
can be quite slow for large queries.
sql_query
.drush migrate:status
.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
Needs review
1.3
Code