[wp-trac] [WordPress Trac] #14254: update_meta_cache fails; query too large?

[WordPress Trac]

#14254: update_meta_cache fails; query too large?
-------------------------------------------------+-------------------------
 Reporter:  newpixel                             |       Owner:  pbearne
     Type:  defect (bug)                         |      Status:  assigned
 Priority:  normal                               |   Milestone:  Future
                                                 |  Release
Component:  Cache API                            |     Version:  2.9.2
 Severity:  normal                               |  Resolution:
 Keywords:  has-patch needs-codex has-unit-      |     Focuses:
  tests                                          |  performance
-------------------------------------------------+-------------------------

Comment (by flixos90):

 Is this ticket still relevant?

 Overall, I can see how the proposed change would improve the situation.
 But I'm slightly worried about introducing this kind of batching in an
 arbitrary place in WordPress Core, as I would imagine the same problem can
 occur in other places too where an SQL `IN` operator is used with variable
 arguments.

 Given all reports of the actual problem here date back 8 years or more, I
 wonder whether this is still happening, and if it is, how have y'all been
 working around it? Given WordPress Core hasn't fixed this, you probably
 found a way yourselves and it'd be good to learn more about that.

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