Re: [sqlite] caching sqlite3_db_mutex()

On 5/25/17, Baruch Burstein wrote: > > Is it safe to cache the mutex pointer returned by > `sqlite3_db_mutex(sqlite3*)`? > Can/does the mutex pointer change thought the life of the `sqlite3` object? > I think so, yes. (Warning: This answer given in the early morning, before coffee!) -- D. Ric

[sqlite] caching sqlite3_db_mutex()

Hi, Is it safe to cache the mutex pointer returned by `sqlite3_db_mutex(sqlite3*)`? Can/does the mutex pointer change thought the life of the `sqlite3` object? Thanks, Baruch -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı ___ sqlite-users maili

[sqlite] Caching model and aging timeout

Hi! I have a few questions/observations about the caching model. Any help clarifying these issues would be greatly appreciated. (I'm working on a Windows Server class OS). 1) Setting the SQLITE_CONFIG_PAGECACHE keyword within sqlite3_config() seems to define a single cache for the instance of

Re: [sqlite] SQLite caching

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

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

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

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

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

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

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

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

Re: [sqlite] caching

I am sorry, I should have made some clarifications about the way the wrapper is implemented, let me answer your concerns. I see many problems here: * It fails if your update or delete from a different database connection or a different process such that the update or delete is not

Re: [sqlite] caching

<[EMAIL PROTECTED]> wrote: > > when an update or delete is made to the database all > queries that are possibly affected are requeried and > cached again rather than being removed, once every 20 > updates/deletes a clean up routine is invoked. I see many problems here: * It fails if your up

[sqlite] caching

Hi, I have a COM component to which sqlite++ library was added, now I want to improve caching of queries. It's already working speeding up nicely by caching each query, but it uses a setting for how many queries to cache and for how long. I believe in automating everything that's possible, so