Re: [sqlite] question about shared cache

2009-03-24 Thread Dan
On Mar 25, 2009, at 12:09 AM, Dave Toll wrote: > Hello list > > > > I have been trying to understand how shared cache works under the > covers, and how a custom VFS should behave when shared cache is > enabled > - can anyone confirm this assumption: > > > > Journal file handles (opened with

[sqlite] question about shared cache

2009-03-24 Thread Dave Toll
Hello list I have been trying to understand how shared cache works under the covers, and how a custom VFS should behave when shared cache is enabled - can anyone confirm this assumption: Journal file handles (opened with SQLITE_OPEN_EXCLUSIVE) are shared between database connections opened

Re: [sqlite] Question about shared cache and read_uncommitted

2007-03-10 Thread Dan Kennedy
On Sat, 2007-03-10 at 22:22 +0900, Brownie wrote: > Thanks Dan, > > > That the first database file was ATTACHed instead of being opened > > directly makes no difference. > > A cache of :memory: database also be shared on shared cache mode ? > Or :memory: database of each connections are

Re: [sqlite] Question about shared cache and read_uncommitted

2007-03-10 Thread Brownie
Thanks Dan, That the first database file was ATTACHed instead of being opened directly makes no difference. A cache of :memory: database also be shared on shared cache mode ? Or :memory: database of each connections are irrelevant ? Regards, 2007/3/10, Dan Kennedy <[EMAIL PROTECTED]>: On

Re: [sqlite] Question about shared cache and read_uncommitted

2007-03-09 Thread Dan Kennedy
On Sat, 2007-03-10 at 14:11 +0900, Brownie wrote: > Hi, > > I have two questions about shared cache mode of SQLite. > > 1. When is shared cache of SQLite deallocated? > A last call of sqlite3_close()? Or end of thread procedure? The former. The shared cache (and shared schema) are reference

[sqlite] Question about shared cache and read_uncommitted

2007-03-09 Thread Brownie
Hi, I have two questions about shared cache mode of SQLite. 1. When is shared cache of SQLite deallocated? A last call of sqlite3_close()? Or end of thread procedure? 2. Can I use read_uncommitted isolation in the following case? (Connection1 and Connection2 is established by the same thread