Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#12289 closed defect (bug) (fixed)

Add comment_parent index to comments table schema

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

  • 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

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

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