> 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. -- 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
