[wp-trac] Re: [WordPress Trac] #7415: "using filesort" in default install

[WordPress Trac]

#7415: "using filesort" in default install
--------------------------+-------------------------------------------------
 Reporter:  dbuser123     |       Owner:  anonymous                                     
     Type:  defect (bug)  |      Status:  new                                           
 Priority:  high          |   Milestone:  2.8                                           
Component:  Optimization  |     Version:  2.7                                           
 Severity:  major         |    Keywords:  database, optimization, slow queries, filesort
--------------------------+-------------------------------------------------

Comment(by ryan):

 Replying to [comment:29 rawalex]:
 > If you need the data and the count, why not just do the query and then a
 mysql_count_rows?  If you are just looking for the count, then severely
 limit the fields you are pulling in (wp_post.* is a bad choice if you
 don't need the data).  Less fields means less data space required.

 We don't need to count the number of rows in the result, we need to count
 the number of rows the query would return if it had no limits. Without
 SQL_CALC_FOUND_ROWS, we have to do a separate COUNT query.

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