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 connections which have multiple DBs are open/ATTACHed. > > Specifically, does SQLite lock the DBs incrementally, as they are > accessed within the transaction? Or does it lock ALL DBs? > > If a transaction accesses only ONE DB, will all DBs be locked for that > transaction? what locking sequence does SQLite execute? > > If a transaction reads from multiple DBs but WRITES to only one DB, > what > locking sequence does SQLite execute? >
Databases are locked as needed - incrementally. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
