[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:  (none)
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Future Release
Component:  Database     |     Version:
 Severity:  normal       |  Resolution:
 Keywords:  needs-patch  |     Focuses:
-------------------------+-----------------------------

Comment (by johnbillion):

 @javorszky Is this something you're willing to work on? As
 `SQL_CALC_FOUND_ROWS` can get slow for a large data set, does the
 replacment `SELECT COUNT(*) WHERE ...` method recommended in the MySQL
 docs have a performance advantage?

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