[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:
                                                 |  spacedmonkey
     Type:  defect (bug)                         |      Status:  reopened
 Priority:  normal                               |   Milestone:  6.4
Component:  Comments                             |     Version:  6.0
 Severity:  minor                                |  Resolution:
 Keywords:  has-patch has-unit-tests needs-dev-  |     Focuses:
  note                                           |  performance
-------------------------------------------------+-------------------------
Changes (by peterwilsoncc):

 * status:  closed => reopened
 * resolution:  fixed =>


Comment:

 I've opened a [https://github.com/WordPress/wordpress-develop/pull/5386
 follow up pull request] to address some concerns I have

 * I'm not sure the name of the function is clear that it only primes the
 parent IDs, not the parent post object 9I think @spacedmonkey had this
 question at some point too)
 * Include priming of the parent ID cache when priming post objects to
 avoid additional queries at a later time.
 * Include a parameter for caching the parent ID of already cached posts.

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