Re: [sqlite] SQLITE transactions failing with multiple threads

On 30 Nov 2010, at 8:11pm, cricketfan wrote: > Drake, I am using SQLITE in threadsafe mode. Transaction inside another > transaction isnt that equivalent of nested transactions? Should that be > allowed? I have no problem opening another handle but just trying to > understand the intricacies,

Re: [sqlite] SQLITE transactions failing with multiple threads

___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/SQLITE-transactions-failing-with-multiple-threads-tp

Re: [sqlite] SQLITE transactions failing with multiple threads

Quoth cricketfan , on 2010-11-30 12:11:52 -0800: > Drake, I am using SQLITE in threadsafe mode. Transaction inside another > transaction isnt that equivalent of nested transactions? Should that be > allowed? SQLite has named savepoints, but not nested BEGIN transactions.

Re: [sqlite] SQLITE transactions failing with multiple threads

nd will gain you no > parallelism in the modes where it works. Aside from that, transaction > state is bound to a handle; you're starting a transaction and then > trying to start another one inside it. > > Open two handles instead. > -- View this message in context: http://old.n

Re: [sqlite] SQLITE transactions failing with multiple threads

On 30 Nov 2010, at 3:49pm, cricketfan wrote: >I have 2 threads in my program, 1st thread is doing inserts into a > table and 2nd thread is trying to update the already inserted columns. > 1. I have bundled the 1000 inserts per transaction in 1st thread. > 2. When I try to start a

Re: [sqlite] SQLITE transactions failing with multiple threads

Quoth cricketfan , on 2010-11-30 07:49:36 -0800: > Also not that both threads are > using the same handle passed by main. No, don't do that. Using the same handle in two threads concurrently can break depending on the SQLite threading mode, and will gain you no

[sqlite] SQLITE transactions failing with multiple threads

. -- View this message in context: http://old.nabble.com/SQLITE-transactions-failing-with-multiple-threads-tp30340806p30340806.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http