> presuming this timeline is chronological, may i assume that step 4 is > committed first in the database?
You mean as a third transaction? No. > and that steps 5 and 6 operate independently? No. > even when threads 1 and 2 open their individual transactions, i see only ONE > journal file > logically i guess i would have expected to see one journal file per open > transaction per thread? You are wrong. Transactions are per-connection and have nothing to do with threads. If you want different transactions in each thread you need to make one connection for each thread. But those transactions won't be able to execute simultaneously. > does step five commit thread 6? does thread 6's rollback only operate on the > "stuff" done in thread 6? Step 5 commits everything in thread 1, thread 1's rollback does nothing. And btw if you checked your return codes from SQLite you'd notice that "begin transaction" fails either in thread 2 or thread 1 (whichever comes last). Pavel On Sat, Feb 5, 2011 at 5:27 PM, David M. Cotter <m...@davecotter.com> wrote: > i'm sure this topic has been beaten to death but i just really want to make > sure. > > i'm using ONE database, and one handle to it on all threads > > here's a theoretical timeline > > ------------------ > 1) thread 1 > begin transaction > do bunches of stuff > > 2) thread 2 > begin transaction > do bunches of stuff > > 3) thread 1 > do more stuff > > 4) thread 0 (main thread) > do atomic operation > > 5) thread 2 > do more stuff > commit transaction > > 6) thread 1 > rollback transaction > ------------------ > > presuming this timeline is chronological, may i assume that step 4 is > committed first in the database? > > and that steps 5 and 6 operate independently? > > even when threads 1 and 2 open their individual transactions, i see only ONE > journal file > logically i guess i would have expected to see one journal file per open > transaction per thread? > > does step five commit thread 6? does thread 6's rollback only operate on the > "stuff" done in thread 6? > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
