On 9/20/16, Kevin O'Gorman <kevinogorm...@gmail.com> wrote:
>   c.execuite("BEGIN TRANSACTION IMMEDIATE")
>
> and is IMMEDIATE the right thing, or do I need EXCLUSIVE.

IMMEDIATE is the right thing.  That lets other readers continue and
new readers to start, but blocks all other writers.

EXCLUSIVE would block everybody - readers and writers - which is more
than you need.

-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to