[wp-trac] [WordPress Trac] #11399: clean_post_cache() generates enormous amounts of queries on sites with lots of pages, revisions or attachments

[WordPress Trac]

#11399: clean_post_cache() generates enormous amounts of queries on sites with lots
of pages, revisions or attachments
-------------------------------------------------+-------------------------
 Reporter:  Denis-de-Bernardy                    |       Owner:
     Type:  defect (bug)                         |      Status:  new
 Priority:  normal                               |   Milestone:  Future
Component:  Optimization                         |  Release
 Severity:  normal                               |     Version:  2.9
 Keywords:  needs-patch dev-feedback has-patch   |  Resolution:
  needs-feedback                                 |
-------------------------------------------------+-------------------------

Comment (by wonderboymusic):

 A problem for every post type. This was a huge problem for forums in
 bbPress with 1000s of topics which combined had 100,000K+ replies - PHP
 would run out of memory because clean_post_cache was stacking 4 queries
 per post resulting in ~600,000 database queries when you edited a giant
 forum. JJJ's essence is here:
 http://bbpress.trac.wordpress.org/browser/branches/plugin/bbp-includes
 /bbp-core-cache.php?rev=4011

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