ting to tell the backend whether to use ILIKE vs.
LIKE LOWER, though personally I'm not using __icontains so I don't
have a dog in this fight :)
From: Ted Gruenloh
To: "django-developers@googlegroups.com"
Sent: Tuesday, October 4, 2011 1
Jonas:
Thanks for the response. The ticket you referenced refers to __iexact. In
that case, I agree with the use of UPPER. My question/suggestion is about
__icontains, which must either use '...LIKE UPPER()' or ILIKE. In my quick
tests, ILIKE wins by about 10% on a table with 1 million rec