Re: [sqlite] Thread sync issue

2013-02-24 Thread Keith Medcalf
inst html e-mail /\ www.asciiribbon.org > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Ashok Pitambar > Sent: Sunday, 24 February, 2013 06:44 > To: Roger Binns; General Discussion of SQLite Database > Subj

Re: [sqlite] Thread sync issue

2013-02-24 Thread Michael Black
Behalf Of Ashok Pitambar Sent: Sunday, February 24, 2013 7:44 AM To: Roger Binns; General Discussion of SQLite Database Subject: Re: [sqlite] Thread sync issue Read point 2 multithread carefully it says "provided no single db connection is used simultaneously in two or more threads&quo

Re: [sqlite] Thread sync issue

2013-02-24 Thread Ashok Pitambar
Read point 2 multithread carefully it says "provided no single db connection is used simultaneously in two or more threads". I am creating one db connection and it is accessed by multiple threads. I am facing while reading the count from tables. There is mismatch due sync issue. Regards, A

Re: [sqlite] Thread sync issue

2013-02-24 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 24/02/13 00:14, Roger Binns wrote: > On 23/02/13 21:23, Ashok Pitambar wrote: >> Sqlite doc says it thread safe ... > > http://www.sqlite.org/threadsafe.html > > What makes you think the doc is wrong? One big gotcha: errors - if you use one conne

Re: [sqlite] Thread sync issue

2013-02-24 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 23/02/13 21:23, Ashok Pitambar wrote: > Sqlite doc says it thread safe ... http://www.sqlite.org/threadsafe.html What makes you think the doc is wrong? Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAlEpy+