[wp-trac] Re: [WordPress Trac] #7633: Lack of an Index on wp_posts.guid Slowing Down Queries

[WordPress Trac]

#7633: Lack of an Index on wp_posts.guid Slowing Down Queries
--------------------------+-------------------------------------------------
 Reporter:  waldojaquith  |        Owner:  anonymous
     Type:  enhancement   |       Status:  new      
 Priority:  normal        |    Milestone:  2.7      
Component:  Optimization  |      Version:  2.6.1    
 Severity:  normal        |   Resolution:           
 Keywords:  guid, mysql   |  
--------------------------+-------------------------------------------------
Comment (by waldojaquith):

 Ah, that ''is'' a good question, Ryan. There are at least a couple of
 instances of that, in fact, such as this one from !FeedWordPress:

 {{{
 SELECT post_date_gmt
 FROM wp_posts
 WHERE post_status = 'publish'
 ORDER BY post_date_gmt DESC
 LIMIT 1
 }}}

 I do intend to create an index on post_date_gmt within my own databases,
 but I'm not familiar enough with how that row is used within !WordPress to
 be able to speak to the merits of modifying WP to do so as a matter of
 course.

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