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? >
The answers to your questions are probably in here http://www.sqlite.org/atomiccommit.html HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
