[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 FolioVision):

 Great work @Guss77. We ran across the same issue and propose
 [https://core.trac.wordpress.org/ticket/58488#ticket a similar solution],
 except with database indexes.

 With all due respect, those who do not have access to sites with a
 million+ comments (@peterwilsoncc, @spacedmonkey) probably should not be
 commenting on this issue. Hopelessly inefficient comment code doesn't
 affect you, we all know that.

 I'd continue to recommend database indexing as it means that when these
 queries are necessary they are very efficient. For small databases, the
 space used is not much.

 The idea that one must introduce object caching or redis or any ultra
 complex caching method (all of which have their own huge downsides) as
 soon as a WordPress site grows beyond toy size/personal weblog is both
 elitist and defeatist. We (Core WordPress developers) could do a lot more
 to allow WordPress to scale to medium size before requiring a fully
 handrolled install and dedicated server or worse multiple servers. I
 understand that many of us make our money (including Automattic) with
 custom solutions but are we so venial that we must cripple WordPress sites
 of even moderate size?

 @Guss77's proposal not to sort if not necessary is such an obvious fix,
 it's hard to believe anyone would argue against it.

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