On 11 May 2017, at 4:12pm, Bill Wade <[email protected]> wrote: > I'd say that "local file system" versus "remote file system" is really more > of a shorthand for the requirement that low-level operations such as locks > and reads behave the way that sqlite expects them to behave. > > > > In particular, locks on remote file systems are notorious for poor behavior.
It’s the word 'remote' which is not clearly explained. In the SQLite documentation, the word 'remote' means you’re accessing it using a networking API not a file system API. It’s the network storage APIs which tend to do locking badly. So if you’re talking to a drive using disk access commands it’s local, even if it’s a RAID array in a 19" rack connected using Thunderbolt. But if you mounted the drive as "SMB:" it’s 'remote' even if it’s physically in your CPU’s box. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
