[wp-trac] [WordPress Trac] #47280: SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17

[WordPress Trac]

#47280: SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17
--------------------------------------+-----------------------------
 Reporter:  javorszky                 |       Owner:  johnbillion
     Type:  enhancement               |      Status:  reviewing
 Priority:  normal                    |   Milestone:  Future Release
Component:  Database                  |     Version:
 Severity:  major                     |  Resolution:
 Keywords:  has-patch has-unit-tests  |     Focuses:  performance
--------------------------------------+-----------------------------

Comment (by xParham):

 Hey @johnbillion, can we also maybe add `count` as an option for the
 `fields` query parameter that would then only run the COUNT query and
 populate the `found_posts`/`total_users` values and skip running the main
 query to save some query time in cases where only the count is needed?

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/47280#comment:20>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform