[wp-trac] Re: [WordPress Trac] #7457: Sticky Posts

[WordPress Trac]

#7457: Sticky Posts
----------------------------------+-----------------------------------------
 Reporter:  ryan                  |        Owner:  anonymous
     Type:  defect                |       Status:  new      
 Priority:  normal                |    Milestone:  2.7      
Component:  General               |      Version:           
 Severity:  normal                |   Resolution:           
 Keywords:  sticky posts blessed  |  
----------------------------------+-----------------------------------------
Comment (by ryan):

 Ordering by menu_order DESC, post_date DESC results in filesort.  I've
 tried adding different keys to get rid of it but haven't hit upon a
 combination that works yet.  Using menu_order does make things cleaner,
 but incurring filesort isn't worth it.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/7457#comment:9>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software