2 ms·
> It's not the database's fault for not being able to write 10M rows to the disk quickly. It usually is though. Being able to write 10m rows quickly is entirel
by bob1029 4y ago
> It's not the database's fault for not being able to write 10M rows to the disk quickly.
It usually is though. Being able to write 10m rows quickly is entirely a matter of how the engine is designed to work and the required durability semantics.
Some designs can write 10m rows to magnetic storage in a few seconds. Others might take minutes.
The most ideal designs (from a raw throughput perspective) leverage batching and can write multiple transactions per disk IO operation.