Re: [sqlite] Strange eviction or bypass of Linux page cache

2013-02-07 Thread James Vanns
> Don't write your database to NFS. I'd guess that your problem is that > NFS driver for some reason thinks that the file was changed on the > server (could be as easy as rounding of file modification time) and > thus re-reads it from NFS server. And it has nothing to do with > SQLite. Nope.

Re: [sqlite] Strange eviction or bypass of Linux page cache

2013-02-07 Thread Pavel Ivanov
> Anyone out there know how to correct this undesirable behaviour? > > PS. This only happens over NFS - local DB files behave as expected and fill > the OS page cache. Don't write your database to NFS. I'd guess that your problem is that NFS driver for some reason thinks that the file was

[sqlite] Strange eviction or bypass of Linux page cache

2013-02-07 Thread James Vanns
(Sorry if this gets posted twice - our damn mail server rewrites outgoing mails so I had to unsubscribe and re-subscribe under a different Email address) Hello list. I'd like to ask someone with more SQLite experience than me a simple question. First, some background; Distribution: Scientific