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