Larry Knibb wrote: > On 15 October 2012 16:35, Clemens Ladisch <clem...@ladisch.de> wrote: >> Which network protocol? And what are the OSes on the clients and on the >> file server? > > The server and clients are Windows machines so I guess (not my area of > expertise) that the protocol is SMB/CIFS?
Yes. The actual protocol (version) depends on the OS version. In theory, locking on Windows works if the server and all clients have the latest service packs, if no computer hangs or crashes, and if the network is reliable. SMB has a clever caching feature called opportunistic locking. It is common pratice do disable it when one sees data corruption; see <http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html>. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
