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.
Advertising
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
