id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
3845	Add db_index to FlatPages 'url' field	jesse.lovelace@…	Adrian Holovaty	"Currently the FlatPage model doesn't have an index on 'url', but always uses 'url' for the lookup in contrib.flatpages.views:
{{{
f = get_object_or_404(FlatPage, url__exact=url, sites__id__exact=settings.SITE_ID)
}}}

I'm not sure how this could hurt in any case since if you only had a few flatpages your index would be small and if you had many it would be crucial.

"		closed	Contrib apps	dev		fixed		dev@…	Ready for checkin	1	0	0	0	0	0