COLLATE NOCASE has the desired effect, like then performs much the same as glob.
pragma case_sensitve_like = had no effect. On Fri, Jun 8, 2018 at 9:29 PM, R Smith <ryansmit...@gmail.com> wrote: > > On 2018/06/08 1:24 PM, Clemens Ladisch wrote: >> >> David Burgess wrote: >>>> >>>> Have you run ANALYZE? >>> >>> Yes. And LIKE now uses the index, but like is still ~100 times slower. >> >> A case-sensitive index cannot be used for a case-insensitive search. >> >> Create a COLLATE NOCASE index, or use GLOB. > > > Or use > pragma case_sensitve_like = 0; > > Actually, I'm not 100% sure now if that will sway the query planner - test > it first, and if it does, kindly let us know. > > > >> >> >> Regards, >> Clemens >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users