[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     |     Focuses:  performance
--------------------------+--------------------------

Comment (by Guss77):

 Replying to [comment:8 spacedmonkey]:
 > @Guss77 How many comments do you have on that site? I am finding this
 hard to replicate this locally.

 The website has > 5M comments, and is running both the database, web
 server and FPM-CGI daemon on a VPC that is equivalent to an AWS EC2 micro
 instance (1 heavily throttled Xeon 6xxx core w/ 1GB RAM). I would expect
 this will repro only on severely memory and CPU constrained
 implementations.

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