Paxdo Presse <pa...@mac.com> wrote: > In the doc, it is indicated that exclusive lock is required to write to the > database. > In this case, it can not be simultaneously other locks for reading (Shared..). > > And in wal mode?
It can, obviously. > Are we to understand that the pending / exclusive locks function differently > and allow simultaneous shared locks? Yes. Note that, with WAL, writers never write to the same areas of files that readers may read from. > What locks/transactions should be used, to allow simultaneous readers and one > writer? The same that are used without WAL. A transaction simply doesn't get blocked in some cases where it used to be. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
