2017-02-15 14:18 GMT+01:00 Cecil Westerhof <cldwester...@gmail.com>: > The OR version is the least efficient and it look likes the BETWEEN > version 2 is the most efficient. It looks like it uses less user and more > sys. >
Which is the most efficient is also dependent on the state of the database itself. I compacted the database and now sometimes NOT BETWEEN is more efficient and sometimes NOT BETWEEN version 2 is more efficient. The OR version is always the least efficient. -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users