This mailing list is amazingly responsive.  That, among SQLite's
features,
makes it very easy use SQLite in our application.

Thank you.

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?
 
-rlehr
Robert Lehr
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to