#12289 closed defect (bug) (fixed)
Add comment_parent index to comments table schema
| Reported by: |
|
Owned by: | |
|---|---|---|---|
| Milestone: | 3.0 | Priority: | normal |
| Severity: | normal | Version: | 2.9.2 |
| Component: | Performance | Keywords: | |
| Focuses: | 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)
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