> Le 20 juil. 2017 à 10:23, Olivier Mascia <o...@integral.be> a écrit : > >> Le 20 juil. 2017 à 07:34, Rowan Worth <row...@dug.com> a écrit : >> >> 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. > > This discussion revolved around WAL mode. > > BEGIN IMMEDIATE by a reader will have no contention impact on writer unless > later in the course of that transaction the reader starts doing things > involving write, which would turn itself to a writer.
And I'm taking that off immediately as I'm obviously wrong here. Sorry for the noise. Some thoughts overlapped. -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users