Re: [sqlite] transaction locks w/ multiple DBs open/ATTACHed(reposted)

2008-06-10 Thread D. Richard Hipp
On Jun 10, 2008, at 7:55 PM, Igor Tandetnik wrote: > D. Richard Hipp <[EMAIL PROTECTED]> wrote: >> On Jun 10, 2008, at 4:04 PM, Robert Lehr wrote: >>> Specifically, does SQLite lock the DBs incrementally, as they are >>> accessed within the transaction? Or does it lock ALL DBs? >> >> Databases a

Re: [sqlite] transaction locks w/ multiple DBs open/ATTACHed(reposted)

2008-06-10 Thread Igor Tandetnik
D. Richard Hipp <[EMAIL PROTECTED]> wrote: > On Jun 10, 2008, at 4:04 PM, Robert Lehr wrote: >> Specifically, does SQLite lock the DBs incrementally, as they are >> accessed within the transaction? Or does it lock ALL DBs? > > Databases are locked as needed - incrementally. So this is another pos

Re: [sqlite] transaction locks w/ multiple DBs open/ATTACHed (reposted)

2008-06-10 Thread D. Richard Hipp
On Jun 10, 2008, at 4:04 PM, Robert Lehr wrote: > I am reposting this question b/c it received no reply previously and > the > answers to my questions will significantly affect our application's > design. > > My current question focuses on SQLite's locking policy for > transactions > on conne

Re: [sqlite] transaction locks w/ multiple DBs open/ATTACHed (reposted)

2008-06-10 Thread Dennis Cote
Robert Lehr wrote: > I am reposting this question b/c it received no reply previously and the > answers to my questions will significantly affect our application's > design. > > My current question focuses on SQLite's locking policy for transactions > on connections which have multiple DBs are ope

Re: [sqlite] transaction locks w/ multiple DBs open/ATTACHed (reposted)

2008-06-10 Thread Dennis Cote
Robert Lehr wrote: > I am reposting this question b/c it received no reply previously and the > answers to my questions will significantly affect our application's > design. > > My current question focuses on SQLite's locking policy for transactions > on connections which have multiple DBs are ope

[sqlite] transaction locks w/ multiple DBs open/ATTACHed (reposted)

2008-06-10 Thread Robert Lehr
I am reposting this question b/c it received no reply previously and the answers to my questions will significantly affect our application's design. My current question focuses on SQLite's locking policy for transactions on connections which have multiple DBs are open/ATTACHed. Specifically, does