On 7/23/06, Hartwig Wiesmann <[EMAIL PROTECTED]> wrote:
Hello,I have read somewhere that BETWEEN is faster than the equivalent expression using comparison operators. Example: ... WHERE Column BETWEEN 1 AND 10 compared with ...WHERE Column >= 1 AND Column <= 10
between is definitely NOT faster. I time tested these two statements SELECT test1 FROM one WHERE id >= 101 AND id <= 110 and SELECT test1 FROM one WHERE id BETWEEN 11 AND 110 30 repetitions of the first statement ran in 10 windows clock cycles. 30 reps of the second took 116,843 cycles. (the id column is indexed) -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com
