[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:  assigned
 Priority:  normal                   |   Milestone:  6.4
Component:  Query                    |     Version:  6.1
 Severity:  normal                   |  Resolution:
 Keywords:  has-patch dev-feedback   |     Focuses:  administration,
  has-unit-tests                     |  performance
-------------------------------------+-------------------------------------

Comment (by LinSoftware):

 I attempted to reproduce Kevin's experience while on trunk, but didn't see
 the reported issue on the second page load of /wp-
 admin/edit.php?post_type=page

 However, I was able to reproduce the issue described in #59319 where the
 page crashes due to out of memory issue. This was reproducible with a data
 set of 60,000 pages. While @spacedmonkey's PR to not cache the terms and
 meta is an improvement, the root of the issue appears to stem from the
 posts_per_page being set to -1, which causes memory exhaustion with a
 large data set.

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