4 ms·
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
by config_yml 6y ago
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_implementations https://sqlite.org/atomiccommit.html#_broken_locking_impleme...
- tutfbhuf 6y agoThat's a serious limitation since many VMs in datacenters have block devices attached over network.
- striking 6y agoI 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.
- tutfbhuf 6y agoBut 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.
- stefanfisk 6y ago”Network filesystems” means stuff like NFS. Networked block devices should generellt be fine AFAIK.