On 5 May 2015, at 11:44am, James K. Lowden <jklowden at schemamania.org> wrote:
> Simon Slavin <slavins at bigfraud.org> wrote: > >> In contrast to NFS both SMB and AFP are designed to support networks >> properly, with caches only on the computer which hosts the file and >> locking correctly implemented. > > Are you saying that SMB clients have no filebuffer cache? Or that > it exists, but is reliably invalidated by writes from other clients? SMB keeps its cache on the computer which hosts the file. So if a file is opened locally the cache is on the only computer concerned. If computer A opens a file on computer B, the file-system cache is on computer B, where all file requests pass through it. Of course a badly written program could keep a local cache too. But that's the programmer's fault and SQLite certainly doesn't have its own cache at that level. Simon.