[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:23 FolioVision]:
 > In that pull request @peterwilsoncc tried to adjust the get_comments()
 calls in different places to remove the ordering where it's not necessary.
 But the exact single place where it matters for our issue was omitted:
 https://github.com/WordPress/wordpress-develop/pull/4571/files#diff-
 1018e4974931b2cea88b413dadc533d3cf535f977c7f3a5f310e0bc7376233a8R522

 Good catch, I've added it in to the dropdown in my PR. I did a quick
 search for `'number'\s*=> 1` in the code base to see if I'd missed any
 similar occurrences but couldn't find any.

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