[wp-trac] [WordPress Trac] #59188: WP_Posts_List_Table causes post, postmeta, and term caches to be primed for all pages in the DB on load

[WordPress Trac]

#59188: WP_Posts_List_Table causes post, postmeta, and term caches to be primed for
all pages in the DB on load
-------------------------------------+-------------------------------------
 Reporter:  kevinfodness             |       Owner:  spacedmonkey
     Type:  defect (bug)             |      Status:  reopened
 Priority:  normal                   |   Milestone:  6.4
Component:  Query                    |     Version:  6.1
 Severity:  normal                   |  Resolution:
 Keywords:  has-patch dev-feedback   |     Focuses:  administration,
  has-unit-tests needs-dev-note      |  performance
-------------------------------------+-------------------------------------

Comment (by peterwilsoncc):

 I initially logged this on the incorrect ticket, so reposting here

 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 (I 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.

 ----

 Jonny and I have discussed whether all of this is appropriate on the PR so
 it will need some additional eyes for a decision.

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