[sqlite] clear cache for performance measure

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. Thanks! ___ sqlite-users mailing list sqlit

Re: [sqlite] clear cache for performance measure

M, Simon Slavin 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 exec

Re: [sqlite] clear cache for performance measure

0 Dec 2010, at 5:16am, Max Vlasov wrote: > > > On Thu, Dec 30, 2010 at 3:23 AM, KimTaein wrote: > > > >> Thanks Simon but that PRAGMA did not work > >> > >> Eric: I am on Windows. Is there a way to force OS cache other than > >> restarting t

[sqlite] max length of integer?

What is the largest number that I can store in integer data type in sqlite? I was not able to find it on sqlite website. Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mai