Re: [sqlite] Multi-thread mode question

they will all commit or rollback together. -Ursprüngliche Nachricht- Von: Neo Anderson [mailto:neo_in_mat...@msn.com] Gesendet: Montag, 09. Februar 2015 06:34 An: General Discussion of SQLite Database Betreff: Re: [sqlite] Multi-thread mode question Does the application work if you configure

Re: [sqlite] Multi-thread mode question

Thanks for your clarification. > From: h...@scigames.at > To: sqlite-users@sqlite.org > Date: Mon, 9 Feb 2015 07:18:29 + > Subject: Re: [sqlite] Multi-thread mode question > > In serialized mode, SQLite will acquire the mutex w

Re: [sqlite] Multi-thread mode question

l commit or rollback together. -Ursprüngliche Nachricht- Von: Neo Anderson [mailto:neo_in_mat...@msn.com] Gesendet: Montag, 09. Februar 2015 06:34 An: General Discussion of SQLite Database Betreff: Re: [sqlite] Multi-thread mode question > Does the application work if you configure SQ

Re: [sqlite] Multi-thread mode question

gt; From: d3c...@gmail.com >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] Multi-thread mode question >> >> it's better to use a connection per thread... the connection resource >isn't >> very big... >> even if you wrap the sqlite3_ calls... you'll need to wr

Re: [sqlite] Multi-thread mode question

entire > lifetime of the statment... Do I need to do this in serialized mode (suppose I use a single connection across multiple threads)? > Date: Sun, 8 Feb 2015 03:31:46 -0800 > From: d3c...@gmail.com > To: sqlite-users@sqlite.org > Subject: Re:

Re: [sqlite] Multi-thread mode question

it's better to use a connection per thread... the connection resource isn't very big... even if you wrap the sqlite3_ calls... you'll need to wrap the entire lifetime of the statment... if you do a execute and then start stepping and getting values while another thread starts another statement...

Re: [sqlite] Multi-thread mode question

On 02/08/2015 04:30 PM, Neo Anderson wrote: The doc says: Multi-thread. In this mode, SQLite can be safely used by multiple threads provided that no single database connection is used simultaneously in two or more threads. I have a scenario that every sqlite3_calls around a single database

[sqlite] Multi-thread mode question

The doc says: Multi-thread. In this mode, SQLite can be safely used by multiple threads provided that no single database connection is used simultaneously in two or more threads. I have a scenario that every sqlite3_calls around a single database connection is protected by a recursive mutex,