![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png){kind=logo}
Opened 18 years ago
Closed 18 years ago
#5785 closed defect (bug) (fixed)
Speedup edit-comments.php comment query
| Reported by: | ryan | Owned by: | ryan |
|---|---|---|---|
| Priority: | normal | Milestone: | 2.5 |
| Component: | General | Version: | |
| Severity: | normal | Keywords: | optimization |
| Cc: | Focuses: |
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)
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