[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 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.

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