[wp-trac] [WordPress Trac] #12289: Add comment_parent index to comments table schema

[WordPress Trac]

#12289: Add comment_parent index to comments table schema
--------------------------+-------------------------------------------------
 Reporter:  ryan          |       Owner:            
     Type:  defect (bug)  |      Status:  new       
 Priority:  normal        |   Milestone:  Unassigned
Component:  Performance   |     Version:  2.9.2     
 Severity:  normal        |    Keywords:            
--------------------------+-------------------------------------------------
 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.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/12289>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software