[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:  3.0                                              
Component:  Optimization       |     Version:  2.9                                              
 Severity:  normal             |    Keywords:  needs-patch dev-feedback has-patch needs-feedback
-------------------------------+--------------------------------------------
Changes (by jwriteclub):

  * keywords:  needs-patch dev-feedback => needs-patch dev-feedback has-
               patch needs-feedback


Comment:

 I added a simple little patch to generate a list of files which need to be
 patch cleared, and then execute them at once. It will discontinue if it's
 already found the id, therefore (in theory) saving some database calls.

 HOWEVER, it only exists within the context of outermost call which does
 NOT include the found array, and, as such, probably won't have much impact
 unless it is propagated across multiple calls, which would require
 changing what calls clean_post_cache -- or at least those calls which have
 the most impact.

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