On 14 Sep 2014, at 8:58pm, jose isaias cabrera <jic...@cinops.xerox.com> wrote:
> "Darren Duncan" wrote... >> >> >> BETWEEN '2014-01-01' AND '2014-01-05' > > Yeah, that is what I am using now. I was trying to get the speed that > supposedly is in the IN clause. :-) Thanks. BETWEEN is fast than IN for any sensible number of IN arguments. BETWEEN gets directly translated to like so A BETWEEN B AND C ==> A >= B AND A <= C IN has to check whether A matches any one of a number of arguments. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
