[wp-trac] Re: [WordPress Trac] #9642: Database Schema Optimizations

[WordPress Trac]

#9642: Database Schema Optimizations
-------------------------------+--------------------------------------------
 Reporter:  Denis-de-Bernardy  |       Owner:  Denis-de-Bernardy
     Type:  defect (bug)       |      Status:  new              
 Priority:  normal             |   Milestone:  2.8              
Component:  Optimization       |     Version:  2.8              
 Severity:  normal             |    Keywords:  has-patch        
-------------------------------+--------------------------------------------

Comment(by Denis-de-Bernardy):

 The most horrible to optimize are the page related queries. MySQL's
 optimizer is stubbornly refuses to use an index on multi-field sorts such
 as menu_order, post_title ASC...

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