Opened 17 years ago
Closed 17 years ago
#5650 closed defect (bug) (fixed)
get_lastcommentmodified() query optimization
| Reported by: |
|
Owned by: | |
|---|---|---|---|
| Milestone: | 2.5 | Priority: | normal |
| Severity: | normal | Version: | 2.3.2 |
| Component: | General | Keywords: | has-patch dev-reviewed |
| Focuses: | Cc: |
Description
get_lastcommentmodified() selects on comment_date_gmt <= $now. comment_data_gmt is not indexed, making this a slow query. I don't see any reason for doing <= $now. Comments can be edited to be in the future; however, future comments are not excluded from any other query. They show in the comments loop.
Attachments (1)
Change History (3)
Note: See
TracTickets for help on using
tickets.
+1