Ticket #5785 (closed defect (bug): fixed)

Opened 1 year ago

Last modified 1 year ago

Speedup edit-comments.php comment query

Reported by: ryan Assigned to: ryan
Priority: normal Milestone: 2.5
Component: General Version:
Severity: normal Keywords: optimization
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

comment_date_gmt_key.diff (1.8 kB) - added by ryan on 02/07/08 00:53:56.

Change History

02/07/08 00:53:56 changed by ryan

  • attachment comment_date_gmt_key.diff added.

02/13/08 19:15:31 changed by ryan

  • status changed from new to closed.
  • resolution set to fixed.

(In [6825]) Add comment_date_gmt key to comments table. Optimize _wp_get_comment_list() query. fixes #5785