[wp-trac] [WordPress Trac] #5785: Speedup edit-comments.php comment query

WordPress Trac wp-trac at lists.automattic.com
Thu Feb 7 00:53:06 GMT 2008


#5785: Speedup edit-comments.php comment query
---------------------+------------------------------------------------------
 Reporter:  ryan     |       Owner:  ryan        
     Type:  defect   |      Status:  new         
 Priority:  normal   |   Milestone:  2.5         
Component:  General  |     Version:              
 Severity:  normal   |    Keywords:  optimization
---------------------+------------------------------------------------------
 The query done by _wp_get_comment_list() does a full table scan and a file
 sort.  Adding a key on comment_date_gmt and forcing it's use in the query
 greatly speeds up this query.

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


More information about the wp-trac mailing list