id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
3373	Better get_page_uri	ryanscheuermann	anonymous	"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."	enhancement	closed	normal		Optimization	2.0.5	normal	invalid	get_page_uri has-patch needs-test