Rowan Worth wrote: > 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.
Then to take a SHARED lock, you have to actually read something from the database, e.g.: BEGIN DEFERRED TRANSACTION; PRAGMA user_version; Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users