[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