Hacker News Reader

SQLite recommends not using network storage:

> You are advised to avoid using SQLite on a network filesystem in the first place, since performance will be slow

https://sqlite.org/atomiccommit.html#_broken_locking_impleme...

That's a serious limitation since many VMs in datacenters have block devices attached over network.

I think this is true for any RDBMS, though. If your block device has high latency, you will see bad perf when the DB tries to fsync.

But the block device latency is usually a order of magnitude lower (microseconds) than the network latency between the database and its clients (milliseconds), except when all clients are located in the same datacenters.

”Network filesystems” means stuff like NFS. Networked block devices should generellt be fine AFAIK.

Reply on news.ycombinator.com