[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:
     Type:  defect (bug)                       |      Status:  reopened
 Priority:  normal                             |   Milestone:  Future
Component:  Cache API                          |  Release
 Severity:  normal                             |     Version:  2.9.2
 Keywords:  has-patch 2nd-opinion needs-codex  |  Resolution:
                                               |     Focuses:
-----------------------------------------------+---------------------------

Comment (by jipmoors):

 As for the batch size I considered a couple of things; since meta_key is
 255 varchar this is a size that we can calculate with, meta_value can be
 4GB, so calculating is fairly useless.


 Perhaps the memory_limit could be used to set a more dynamic baseline, but
 by adding the filter option I thought it best to leave it at a relative
 low value and let caching plugins or users decide for themselves if they
 want to modify this to minimise the multidimensional overhead added.


 Thoughts are welcome of course.

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