You might also worry about your OS's page cache affecting your result. In modern linuxes you can say
# sync # echo 1 > /proc/sys/vm/drop_caches That will free the page cache. Eric On Wed, Dec 29, 2010 at 6:11 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
