On 4 Nov 2014, at 5:45pm, Mike McWhinney <elja...@sbcglobal.net> wrote:
> I am getting random locking errors during the execution of my program. The > program resides on a network and each client has a mapped share > with full read/write access to the folder as well as the .db file used by > SQLite. I don't know if this is what's causing your specific problem, but ... <https://www.sqlite.org/whentouse.html> "SQLite will work over a network filesystem, but because of the latency associated with most network filesystems, performance will not be great. Also, the file locking logic of many network filesystems implementation contains bugs (on both Unix and Windows). If file locking does not work like it should, it might be possible for two or more client programs to modify the same part of the same database at the same time, resulting in database corruption. Because this problem results from bugs in the underlying filesystem implementation, there is nothing SQLite can do to prevent it. A good rule of thumb is that you should avoid using SQLite in situations where the same database will be accessed simultaneously from many computers over a network filesystem." Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
