[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:11 spacedmonkey]:
 > @Guss77 Are you using object caching. A site with 5M should really be
 using object caching...

 We're not using an object cache - its will use RAM that we cannot afford.
 Generally - IMHO - using an object cache to cache database results seems
 counterintuitive: the same RAM and CPU can better be used by your database
 server's internal caching which must be better - it can cache more
 effectively much closer to the data.

 Regardless whether it is a good idea to use an object cache or not - it
 looks like disabling sorting in a query that absolutely does not need
 sorting, solves the problem, so if a small change with no adverse effects
 negates the need for complex and expensive infrastructure (and a first
 expensive query), why not just do that?

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