On 4 Oct 2011, at 9:19 AM, Jonas H. wrote: > On 10/04/2011 05:51 PM, Ted Gruenloh wrote: >> The django online documentation mentions that the SQL equivalent for >> __icontains is something like: >> >> SELECT ... WHERE headline ILIKE '%Lennon%'; >> However, for postgresql - one of the dbs that actually supports ILIKE - I >> noticed __icontains was actually performing something similar to: >> SELECT ... WHERE LOWER(headline) LIKE LOWER('%Lennon%'); >> >> The ILIKE is obviously much faster [...] > > https://code.djangoproject.com/ticket/3575
Though apparently pg 9.1's trigram indexes can be used for ILIKE searches (but aren't a win for all query patterns). It seems to me it'd be worthwhile to have a setting 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 :) -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-developers@googlegroups.com. To unsubscribe from this group, send email to django-developers+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-developers?hl=en.