[wp-trac] Re: [WordPress Trac] #9864: Performance issues with large number of pages

[WordPress Trac]

#9864: Performance issues with large number of pages
--------------------------+-------------------------------------------------
 Reporter:  pp19dd        |       Owner:  Denis-de-Bernardy
     Type:  defect (bug)  |      Status:  new              
 Priority:  normal        |   Milestone:  Future Release   
Component:  Performance   |     Version:  2.7.1            
 Severity:  normal        |    Keywords:  2nd-opinion      
--------------------------+-------------------------------------------------

Comment(by josephscott):

 That query appears to never use any of the current indexes.  It's the
 ORDER BY clause that is causing the indexes to not be usable.  Perhaps
 it's worth leaving the ORDER BY off and sorting the results in PHP,
 outside of the DB.

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