[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):

 We'd definitely need an index on menu_order for the query not to suck.  We
 need an index on it anyway for the page query.  We should only add
 menu_order to the query when there are stickies, so we might still want to
 store sticky posts in options.  stick_post() would add it to options and
 set menu_order to 1. It's worth a try.  Anyone want to try EXPLAINing the
 posts query with menu_order and different indexes (menu_order, post_date)
 and see how it performs?

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