SQLite Forum

SQLite with NFS + cachefilesd
Login
I know, I know! It is not recommended to use SQLite over NFS.

I still want to do it though, and I'm trying to improve performance by enabling NFS caching with cachefilesd.

That works well for reads on regular files located on the NFS share. However it doesn't seem to improve SQLite queries performance at all.

Does anyone has any idea why? 

I've read stuff about SQLite being seek intensive, about O_DIRECT access, but know pretty much nothing about all that.

Even better, if anyone has a solution to have SQLite work with cachefilesd, I'm interested to hear it!