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
3575	[patch] iexact searches should use LOWER() not ILIKE	Jack Moffitt <metajack@…>	nobody	"Currently queries using field__iexact=""blah"" translate to field ILIKE 'blah'.  This is really inefficient because ILIKE queries (since they are for pattern matching) cannot be indexed and the whole table must be scanned.  If LOWER(field) = LOWER('blah') is used, it accomplishes the same thing, but an index can be created for LOWER(field) that eliminates the table scan.

This is a little tricky since the default substitution is only on the operator and the right operand, but this patch adds a column substitution array as well.  This patch should probably be applied across all backends where LOWER() is supported.  Currently it only changes the postgresql_psycopg2 backend."		new	Database layer (models, ORM)	dev				metajack@… tofu@…	Unreviewed	1	0	0	0