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

 Replying to [comment:36 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 think this makes sense. It appears there is potential to improve the
 speed with an index but if removing the orderby will get the code part of
 the way there, then it makes sense to do that.

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