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

 In `get_comment_count` we could change parameters passed to
 WP_Comment_Query to `orderby` => `none`. This would solve this issue. We
 could consider making this change to `WP_Comment_Query` to order orderby
 => none if fields => count, maybe in another ticket.

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