[wp-trac] [WordPress Trac] #4366: Comment table could use some more indices

[WordPress Trac]

#4366: Comment table could use some more indices
-------------------------+--------------------------------------------------
 Reporter:  markjaquith  |       Owner:                
     Type:  enhancement  |      Status:  assigned      
 Priority:  normal       |   Milestone:  Future Release
Component:  Performance  |     Version:                
 Severity:  normal       |    Keywords:  needs-patch   
-------------------------+--------------------------------------------------

Comment(by mdawaffe):

 We already have a good index for this: comment_date_gmt.  Attached is a
 patch that limits the query to looking for matches within the last 1 hour
 (arbitrary time period).

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