[wp-trac] [WordPress Trac] #10469: use of SQL_CALC_FOUND_ROWS needs to be eliminated

[WordPress Trac]

#10469: use of SQL_CALC_FOUND_ROWS needs to be eliminated
--------------------------+-----------------------------
 Reporter:  _ck_          |       Owner:  ryan
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Future Release
Component:  Query         |     Version:  2.9
 Severity:  normal        |  Resolution:
 Keywords:  dev-feedback  |
--------------------------+-----------------------------

Comment (by pixelgeek):

 Just wanted to add my two cents to this. SQL_CALC_FOUND_ROWS is causing my
 server to become unresponsive every day or two.

 I've been tracking down some performance issues on the server and the one
 issue I am left with is the huge load that the SQL_CALC_FOUND_ROWS in
 query.php cause on a regular basis. Especially during searches.

 Perhaps my site is not in the normal scope of a standard WP site. I get
 about 16,000 visitors a day and generates from 450-500,000 pageviews a
 month.

 I keep my database optimized and the codebase up to date but my mysql-
 slow.log file is littered with these calls and it does eventually bring my
 machine down. Routinely.

 This seems to be a very slow mySQL call and it would be great if there was
 a way to speed the pagination of the site up by using a more efficient
 call

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/10469#comment:10>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software