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

Opened 4 years ago

Last modified 4 years ago

Add comment_date key to comments table

Reported by: ryan Owned by: anonymous
Priority: normal Milestone: 2.5
Component: General Version:
Severity: normal Keywords:
Cc:

Description

This will improve performance of the get_lastcommentmodified() query.

Attachments

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

Change History

ryan — 4 years ago

comment:1   ryan — 4 years ago

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

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

comment:2   ryan — 4 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.