#12289 closed defect (bug) (fixed)
Add comment_parent index to comments table schema
| Reported by: |
|
Owned by: | |
|---|---|---|---|
| Priority: | normal | Milestone: | 3.0 |
| Component: | Performance | Version: | 2.9.2 |
| Severity: | normal | Keywords: | |
| Cc: |
Description
wp_delete_comment() generates queries like this when reparenting children.
SELECT comment_ID FROM wp_comments WHERE comment_parent = 3266619
This is very slow for large comments tables.
Change History (3)
comment:1
automattor — 3 years ago
- Resolution set to fixed
- Status changed from new to closed
comment:2
automattor — 3 years ago
Note: See
TracTickets for help on using
tickets.

(In [13227]) Add an index on comment_parent to speed up wp_delete_comment() reparenting queries. fixes #12289