[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:
Component:  Cache                           |     Version:  2.9.2
 Severity:  normal                          |  Resolution:
 Keywords:  reporter-feedback dev-feedback  |
--------------------------------------------+-----------------------
Changes (by mpvanwinkle77):

 * cc: mpvanwinkle77 (added)
 * keywords:  reporter-feedback => reporter-feedback dev-feedback
 * status:  closed => reopened
 * component:  General => Cache
 * resolution:  worksforme =>


Comment:

 I've run into this issue ... though to clarify it exhausts the available
 PHP memory which is set to 512M. The cause in my case is that I am
 importing 37,000+ posts and so when when update_meta_cache_runs after the
 import it first has the massive query SELECT ... IN(37000 IDS!!!) but then
 it tries to loop over the values returned and add them to the cache.

 I'm not sure what the best solution would be. In my case it's probably to
 import fewer posts at once. But it is worth considering how to make the
 operation more scalable.

 Cheers,

 Mike

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/14254#comment:3>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software