Opened 2 months ago
#59488 new enhancement
Add index to comment_type and comment_approved fields in comment table
| Reported by: |
|
Owned by: | |
|---|---|---|---|
| Milestone: | Awaiting Review | Priority: | normal |
| Severity: | normal | Version: | 3.0 |
| Component: | Comments | Keywords: | |
| Focuses: | performance | Cc: |
Description
Follow on from #58368
It is common to query comments by comment_type or comment_approved. There are several query done in the admin to get counts for different screens. But for sites with many comments, this results in slow returning queries. Add database indexes to these two fields to improve database performance.
Note: See
TracTickets for help on using
tickets.