[wp-trac] [WordPress Trac] #5650: get_lastcommentmodified() query optimization

WordPress Trac wp-trac at lists.automattic.com
Sat Jan 12 17:20:09 GMT 2008

#5650: get_lastcommentmodified() query optimization
 Reporter:  ryan     |       Owner:  anonymous
     Type:  defect   |      Status:  new      
 Priority:  normal   |   Milestone:  2.5      
Component:  General  |     Version:  2.3.2    
 Severity:  normal   |    Keywords:           
 get_lastcommentmodified() selects on comment_date_gmt <= $now.
 comment_data_gmt is not indexed, making this a slow query.  I don't see
 any reason for doing <= $now.  Comments can be edited to be in the future;
 however, future comments are not excluded from any other query.  They show
 in the comments loop.

Ticket URL: <http://trac.wordpress.org/ticket/5650>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software

More information about the wp-trac mailing list