Opened 18 years ago
Closed 18 years ago
#5785 closed defect (bug) (fixed)
Speedup edit-comments.php comment query
| Reported by: |
|
Owned by: |
|
|---|---|---|---|
| Milestone: | 2.5 | Priority: | normal |
| Severity: | normal | Version: | |
| Component: | General | Keywords: | optimization |
| Focuses: | Cc: |
Description
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.
Attachments (1)
Change History (2)
Note: See
TracTickets for help on using
tickets.
(In [6825]) Add comment_date_gmt key to comments table. Optimize _wp_get_comment_list() query. fixes #5785