On 18 July 2017 at 21:43, David Raymond <david.raym...@tomtom.com> wrote:

> You can run "begin deferred transaction" then walk away for 3 months
> without upsetting anything. If you need the precise timing then why not
> just use "begin immediate"?
>

IMMEDIATE would take a RESERVED lock which is clearly not desired in this
case -- the reader only wants a SHARED lock so as to minimise contention
with the writer.

 -Rowan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to