Re:15k inserts/s with Rust and SQLite (2021)
by jandrewrogers on Sunday April 02, 2023 @09:37PM
(#35417515)
Counterintuitively, write performance in modern databases is primarily constrained by disk read performance.
That said, it is increasingly rare for disk I/O to be a bottleneck for inserts. When your storage will happily sustain 10+ GB/s of write throughput, you tend to run out of things like network and memory bandwidth first.
That said, it is increasingly rare for disk I/O to be a bottleneck for inserts. When your storage will happily sustain 10+ GB/s of write throughput, you tend to run out of things like network and memory bandwidth first.