[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 Denis-de-Bernardy):

 the query is:

 SELECT * FROM wp_posts  WHERE (post_type = 'page' AND post_status =
 'publish')     ORDER BY menu_order, post_title ASC

 please alter your database, and add an index on (post_type, post_status).
 see whether that makes any difference.

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