wp_check_post_hierarchy_for_loops can run alot of queries

[westi]

If you have a post with alot of revisions and you save a new revision we will scan through all the revisions checking them out even though they are not really hierarchical.

This means that the revision save doesn't work as the page times out while still running all the queries.

We could probably either do some caching with a better call to get_posts first or not run this code for revisions.

[markjaquith]

Just skip it for revisions.

[nacin]

Cheap fix for 3.1: Don't fire the filter for revisions. Untested.

[ryan]

The only time I see a revision processed is when autosave triggers. The loop checker walks up the autosave's 'page' parents. I see no revisions beyond the one autosave revision being processed.

[westi]

I'm still trying to reproduce this with core post types and understand why the CPT I'm seeing this with is different.

[westi]

Hmm this was a incorrect bug report.

The alot of queries are caused by something else.

[westi]

Part of the issue is #11399 - clean_post_cache and alot of revisions isn't fun.