[wp-trac] [WordPress Trac] #59488: Add index to comment_type and comment_approved fields in comment table

[WordPress Trac]

#59488: Add index to comment_type and comment_approved fields in comment table
--------------------------+------------------------------
 Reporter:  spacedmonkey  |       Owner:  (none)
     Type:  enhancement   |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Comments      |     Version:  3.0
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:  performance
--------------------------+------------------------------

Comment (by spacedmonkey):

 The gutenberg team is exploring inline comments. See
 [https://github.com/WordPress/gutenberg/issues/59445 ticket].

 This ticket adds a new a custom comment type. This means that the new
 endpoints / code will query by comment type. As the comment table might
 get much large ( because of many inline comment ) these query will likely
 get much slower.

 Adding an index here is simple, an a index for comment type, makes sense,
 as other table, like post index their type ( post type ).

 Pinging members of the performance in hopes this change makes it into WP
 6.8.

 CC @flixos90 @swissspidy @joemcgill @mukesh27

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/59488#comment:1>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform