Better get_page_uri

[ryanscheuermann]

Upon testing the queries on some of my sites, I found that there were a LOT more queries for pages that were deeper/farther down in the page hierarchy. I am using get_page_link to get the link for pages on the navigation. This function calls get_page_uri which in turn calls get_page over and over until it builds the tree. When you call get_page, you run a SELECT * FROM wp_posts query. List all your pages, and you've now SELECT *'d every single page.

I've attached a patch that builds the hierarchy from 1 query instead of multiple.

[ryanscheuermann]

This ticket could also be modified and applied to 2.0.6. I've attached that patch also.

[ryanscheuermann]

fixed bug: include attachment uris

[ryanscheuermann]

faster get_page_uri for WP 2.0.5

[DD32]

WordPress no longer selects every page on such a query, Closing as invalid.