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
