Thanks Simon but that PRAGMA did not work.... Eric: I am on Windows. Is there a way to force OS cache other than restarting the machine?
> Date: Wed, 29 Dec 2010 18:22:31 -0600 > From: eas....@gmail.com > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] clear cache for performance measure > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
