Re: [sqlite] SQLite caching

2009-02-23 Thread Simon
oun...@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 >

Re: [sqlite] SQLite caching

2009-02-23 Thread Griggs, Donald
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 is

Re: [sqlite] SQLite caching

2009-02-23 Thread Simon
On linux, caching is always to your advantage: When reading a sector on disk, the kernel copies the sector in ram, in a cache, and then pass this information to the process that needs to read it. When writting, it automatically writes in ram and buffers the write on disk for later (with sqlite, t

Re: [sqlite] SQLite caching

2009-02-23 Thread Alexey Pechnikov
Hello! On Monday 23 February 2009 12:58:36 manohar s wrote: > 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. But why? Caching is very nice instrument. All databases are us

Re: [sqlite] SQLite caching

2009-02-23 Thread manohar s
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, manohar s wrote: > > > Hi, > >

Re: [sqlite] SQLite caching

2009-02-23 Thread Dan
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 gi

Re: [sqlite] SQLite caching

2009-02-23 Thread Jonas Sandman
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 problem is > SQLite seems

[sqlite] SQLite caching

2009-02-22 Thread manohar s
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