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. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users