Re: [sqlite] Multi-thread mode question

2015-02-09 Thread Dan Kennedy
y 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

2015-02-08 Thread Neo Anderson
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 when

Re: [sqlite] Multi-thread mode question

2015-02-08 Thread Hick Gunter
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

2015-02-08 Thread Keith Medcalf
: nothing works and no one knows why. >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Neo Anderson >Sent: Sunday, 8 February, 2015 22:34 >To: General Discussion of SQLite Database >Subject: Re: [sqlite]

Re: [sqlite] Multi-thread mode question

2015-02-08 Thread Neo Anderson
the 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: [sqlite] Multi-thread mode question

2015-02-08 Thread J Decker
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... t

Re: [sqlite] Multi-thread mode question

2015-02-08 Thread Dan Kennedy
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 conn