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

Reply via email to