Re: [sqlite] sqlite-users Digest, Vol 105, Issue 13

On 9/14/2016 11:49 AM, Alex Ward wrote: Just to clarify, when you talked about 'starting' and 'ending' a read can I take that to mean the time between sqlite3_prepare and sqlite3_finalize? Statement execution starts with the first sqlite3_step after sqlite3_prepare or the most recent

Re: [sqlite] sqlite-users Digest, Vol 105, Issue 13

On 14 Sep 2016, at 4:49pm, Alex Ward wrote: > In my original post I said we had done that and it didn’t help, but we just > locked the step, not the prepare/step/finalize so I'm guessing if we lock all > three we will be ok. It is not enough to lock the _prepare, lock the

Re: [sqlite] sqlite-users Digest, Vol 105, Issue 13

> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Igor Tandetnik > Realize that a transaction is a property of a connection, not a thread or a > query. Suppose thread A starts a read at time T and ends it at time > T+20; and thread B starts a read on