3 ms·
The SQLite docs seem to caution against some broken NFS implementations and mentions Apple explicitly, but otherwise imply that NFS should work.
by fulafel 6y ago
The SQLite docs seem to caution against some broken NFS implementations and mentions Apple explicitly, but otherwise imply that NFS should work.
- rythie 6y agoIt’s very slow at writing over NFS. I wrote a simple python script writing 1000 entries, committing after each one, in WAL mode. In Fedora 22 VMs, NFS4.2 default settings, no security, SSD on host machine. - local speed = 2 seconds - NFS to another VM = 31 seconds - NFS via localhost = 17 seconds
- fulafel 6y agoInteresting. 17-31 ms per write is about what a write and sync used to cost on spinning disks. Could still be ok for some use cases.
- rythie 6y agoI tried the same test on a different system with spinning drives, it took 1 minute 43 seconds. The resulting file is 12kb (all inserts, no deletes or updates). It’s sync writes that are slow.