Re: [sqlite] SQLite caching

wrote: > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of manohar s > Sent: Monday, February 23, 2009 4:59 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite caching > > Thanks for your quick replies, alt

Re: [sqlite] SQLite caching

From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of manohar s Sent: Monday, February 23, 2009 4:59 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite caching Thanks for your quick replies, although restarting my machine, disc cache

Re: [sqlite] SQLite caching

Thanks for your quick replies, although restarting my machine, disc cache is cleared, I am trying to find an utility which could do the job without requiring a restart. Regards, Manohar.S On Mon, Feb 23, 2009 at 1:47 PM, Dan wrote: > > On Feb 23, 2009, at 2:44 PM,

Re: [sqlite] SQLite caching

On Feb 23, 2009, at 2:44 PM, manohar s wrote: > Hi, > I am doing some performance analysis on my SQLite queries. The > problem is > SQLite seems to be caching query results. > I tried restarting my program, that is not helping. only if i don't > access > that database for 2 days then it is

Re: [sqlite] SQLite caching

Isn't it more likely that your database is pulled up into the OS disk cache? Try rebooting the computer between runs and the cache should be cleared. On Mon, Feb 23, 2009 at 8:44 AM, manohar s wrote: > Hi, > I am doing some performance analysis on my SQLite queries. The

[sqlite] SQLite caching

Hi, I am doing some performance analysis on my SQLite queries. The problem is SQLite seems to be caching query results. I tried restarting my program, that is not helping. only if i don't access that database for 2 days then it is giving proper profile data. * Question* 1) How can I disable query