Re:Many small queries are efficient in SQLite
by striking on Tuesday February 16, 2021 @01:48PM
(#26157303)
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.
[ Parent
| on HN ]
Re:Many small queries are efficient in SQLite
by tutfbhuf on Wednesday February 17, 2021 @02:33AM
(#26163713)
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.