> 1) If shared, then the second threads insert is part of the transaction and > should succeed. > 2) No. > 3) If the connection is shared between threads, there can only be 1 txn at a > time. The second threads attempt to begin a txn will result in an error that > indicates a txn is already active. To be clear, when using a shared cache and more than one sqlite3 connection object, only one transaction will exist at a time, correct? However, if it is not using the shared cache, you can have a transaction opened up for each thread?
Cheers, Shawn _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users