[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:  spacedmonkey
     Type:  defect (bug)              |      Status:  assigned
 Priority:  normal                    |   Milestone:  6.4
Component:  Comments                  |     Version:  6.0
 Severity:  minor                     |  Resolution:
 Keywords:  has-patch has-unit-tests  |     Focuses:  performance
--------------------------------------+---------------------------
Changes (by spacedmonkey):

 * owner:  peterwilsoncc => spacedmonkey


Comment:

 So after more discovery, I believe this is the best path forward.

 1. Commit [https://github.com/WordPress/wordpress-develop/pull/5341 PR].
 The orders do not fix this issue 100% but do not the database queries
 better.
 2. I have created a follow on ticket #59488. This adds database indexes to
 the two fields that are queried in these counts. This is a none trival
 ticket, as we have to discuss if you updating existing sites.

 I have taken over this ticket from @peterwilsoncc. If we agrees, I will
 commit.

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