[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.5
Component:  Optimization                           |     Version:  2.9
 Severity:  normal                                 |  Resolution:
 Keywords:  dev-feedback has-patch needs-feedback  |
---------------------------------------------------+------------------

Comment (by simonwheatley):

 Replying to [comment:15 simonwheatley]:
 > I think there is an issue with revision caches hanging around when posts
 are deleted in 11399.sw.2.diff. Possibly either manually call
 `clean_post_cache` on each revision within `wp_delete_post`, or have a
 boolean "hard" parameter for `clean_post_cache` which includes the
 revisions if set but defaults to off.

 False alarm. Turns out this is the product of my fevered imagination,
 `wp_delete_post` calls `wp_delete_revision` on each revision earlier in
 the function, and this will clean all the post caches.

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