[wp-trac] [WordPress Trac] #58368: WordPress dashboard is very slow when there are many comments (and the database isn't great)

[WordPress Trac]

#58368: WordPress dashboard is very slow when there are many comments (and the
database isn't great)
--------------------------------------+--------------------------
 Reporter:  Guss77                    |       Owner:  (none)
     Type:  defect (bug)              |      Status:  new
 Priority:  normal                    |   Milestone:  6.3
Component:  Comments                  |     Version:  6.2.2
 Severity:  minor                     |  Resolution:
 Keywords:  has-patch has-unit-tests  |     Focuses:  performance
--------------------------------------+--------------------------

Comment (by spacedmonkey):

 Replying to [comment:32 FolioVision]:

 >
 > As I explained in our ticket the `comment_type` **index** is what really
 helps: #58488
 >

 I said this above and was told i was wrong.

 > I think the biggest issue here is that comment_type does not have an
 index. I feel like it really should. This will likely fix these issues.


 I am not enjoying the tone of this ticket. I am trying to help getting a
 fix committed to core and getting rude responses. Please keep these
 comments civil.

 I think the fix for this is two fold.

 Remove orderby for count to WP_Comment_Query and add a comment_type index.
 I think the index maybe have to be another ticket. Adding an index is not
 simple, as it locks the table.

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