Re: [sqlite] Does Attach improve Concurrency ?

2007-06-05 Thread BardzoTajneKonto
> >> Does > >> using separate databases and attaching them improve concurrency (by > >> providing finer-grained locking)? > > > > Yes it does. You can open a connection to a memory database, store each > table > > in a separate database and attach them if needed. I'v already changed > > sqlite

Re: [sqlite] Does Attach improve Concurrency ?

2007-06-05 Thread Christian Smith
Eduardo Morras uttered: At 19:32 01/06/2007, you wrote: When you have a connection with multiple attached databases and the connection acquires an exclusive lock, does it always lock all attached databases or does it keep track of which databases require the lock? Does using separate

Re: [sqlite] Does Attach improve Concurrency ?

2007-06-05 Thread Christian Smith
[EMAIL PROTECTED] uttered: When you have a connection with multiple attached databases and the connection acquires an exclusive lock, does it always lock all attached databases or does it keep track of which databases require the lock? 1st process: C:\Documents and

Re: [sqlite] Does Attach improve Concurrency ?

2007-06-01 Thread Eduardo Morras
At 19:32 01/06/2007, you wrote: >When you have a connection with multiple attached databases and the >connection acquires an exclusive lock, does it always lock all attached >databases or does it keep track of which databases require the lock? Does >using separate databases and attaching them

[sqlite] Does Attach improve Concurrency ?

2007-06-01 Thread Samuel R. Neff
When you have a connection with multiple attached databases and the connection acquires an exclusive lock, does it always lock all attached databases or does it keep track of which databases require the lock? Does using separate databases and attaching them improve concurrency (by providing