[wp-trac] [WordPress Trac] #63284: _prime_post_caches is getting called unchunked

[WordPress Trac]

#63284: _prime_post_caches is getting called unchunked
--------------------------+-----------------------------
 Reporter:  ckeeney       |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  General       |    Version:  6.7.2
 Severity:  major         |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 I setup a local environment where I can reliably reproduce this issue.
 The local environment has just two plugins active: Query Monitor and Redis
 Object Cache.  I also stripped away all of my functions.php except for
 registering my custom post types.  This environment has 16,000+ "Article"
 post types.

 Steps to reproduce:
 1. Navigate to the Article index on wp-admin (/wp-
 admin/edit.php?post_type=article)
 2. Open Query Monitor -> Database Queries -> Slow Queries
 3. Observe query for SELECT wp_posts.* FROM wp_posts WHERE ID IN (~16,000
 individually listed IDs here)
 4. If you do not see the giant query on Step 3, use the Object Cache->
 Flush Cache tool provided by the Redis Object Cache toolbar at the top of
 the page.
 5. Refresh the page and observe the query described in step 3.

 [[Image(https://i.imgur.com/qZUpt9S.png)]]

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/63284>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform