Ticket #5773 (closed defect: fixed)

Opened 5 months ago

Last modified 5 months ago

Add comment_date key to comments table

Reported by: ryan Assigned to: 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 (2.0 kB) - added by ryan on 02/05/08 17:38:26.

Change History

02/05/08 17:38:26 changed by ryan

  • attachment comment_date_key.diff added.

02/05/08 18:04:18 changed by ryan

  • 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

02/05/08 23:30:00 changed by ryan

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