WordPress.org

Make WordPress Core

Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#5773 closed defect (bug) (fixed)

Add comment_date key to comments table

Reported by: ryan Owned by:
Milestone: 2.5 Priority: normal
Severity: normal Version:
Component: General Keywords:
Focuses: Cc:
PR Number:

Description

This will improve performance of the get_lastcommentmodified() query.

Attachments (1)

comment_date_key.diff (2.0 KB) - added by ryan 12 years ago.

Download all attachments as: .zip

Change History (3)

#1 @ryan
12 years ago

  • Resolution set to fixed
  • Status changed from new to closed

(In [6729]) Add key on comment_approved,comment_date to speed up last comment modified queries. fixes #5773

#2 @ryan
12 years ago

(In [6736]) Order by and index on comment_date_gmt instead of comment_date to insulate order from offset changes. fixes #5773

Note: See TracTickets for help on using tickets.