[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.4
Component:  Comments                  |     Version:  6.2.2
 Severity:  minor                     |  Resolution:
 Keywords:  has-patch has-unit-tests  |     Focuses:  performance
--------------------------------------+--------------------------

Comment (by Guss77):

 @spacedmonkey and @FolioVision - is it possible to leave the issue of the
 `comment_type` index in #58488 and have this issue focused on removing the
 ordering clauses when issuing `wp_count_comments()` - as: (a) that was the
 original reported issue and the index issue is unrelated to the original
 report (i.e. it does not help nor hinder a solution); and (b) the index
 issue has a prior report about it (as noted).

 I would really love to have the slowness of `wp_count_comments()` fixed in
 the 6.3 beta, before we (who are affected) have to update and patch
 manually again.

 Several good solutions have been offered to solve the problem in core -
 can we have a discussion on which is best and just go with it?

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