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

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

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

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