WordPress.org

Make WordPress Core

Opened 4 years ago

Closed 4 years ago

Last modified 4 years ago

#12289 closed defect (bug) (fixed)

Add comment_parent index to comments table schema

Reported by: ryan 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)

comment:1 automattor4 years ago

  • Resolution set to fixed
  • Status changed from new to closed

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

comment:2 automattor4 years ago

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

comment:3 nacin4 years ago

  • Milestone changed from Unassigned to 3.0
Note: See TracTickets for help on using tickets.