[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:  normal                          |  Resolution:
 Keywords:  has-patch has-unit-tests early  |     Focuses:  performance
--------------------------------------------+-----------------------------

Comment (by JaworskiMatt):

 This is a very important improvement no matter what MySQL version the
 website is using. Huge databases end up being extremely slow because of
 this, and in case of our plugin WordPress insists on counting the rows in
 our `WP_Query`ies even when we don't need it for anything, leading to
 major performance degradation. Trying to circumvent it with filters has
 never worked fine.

 We hope this makes it into Core sooner than later.

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