3 ms·
> For ACID storage, one transaction per disk rotation is pretty much a theoretical limit for sustained performance. Why? There's nothing about "all or nothing
by anamax 18y ago
> For ACID storage, one transaction per disk rotation is pretty much a theoretical limit for sustained performance.
Why? There's nothing about "all or nothing" that forbids performing independent application-level commits with a single implementation-level commit. And, it's even possible to do application-level-dependent commits at the same time. (Yes, it's tricky.)
And, you can have commits on different spindles. And, you can do multiple writes during a single rotation.