On 12 May 2014, at 4:05pm, Jan Slodicka wrote: > And whether we'll call it "LIKE optimization" or "using BETWEEN", the > problem remains basically the same.
They're not the same, Jan. This optimization is for one very specific use of LIKE: where the match string has no wildcards except for a percent sign at the end. I don't think it's out of order to say "Wildcard matching is wildcard matching, which is slow. If you want fast, use BETWEEN.". Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
