On 30 Dec 2010, at 12:02am, KimTaein wrote: > How can I clear my sqlite db cache? > I am comparing 2 different queries' running time but because results are > cached and 2nd run of the same query execute much faster.
I don't know whether it actually works, but setting PRAGMA cache_size = 0; PRAGMA cache_size = 2000; seems as if it would help. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
