[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
-------------------------------+--------------------------------------------

Comment(by jwriteclub):

 I don't think that there is a fix for the issue of recursing, at least not
 on the face of it.

 It might be possible to generate a list of found pages (aka dynamic
 programming) to help prevent duplicate recursion, but the fundamental
 problem of recursing could only be "solved" by changing how the heirarchy
 is represented in the database. Rather than storing "parent" values, left
 and right node values could be stored (in essence, storing the tree
 traversal in the DB). Unfortunately, this would represent a major
 modification to the table, which I don't think makes sense.

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