Re:What database would you use to store (min) 10 billion obj...
by anamax on Friday May 08, 2009 @09:19AM
(#599578)
> 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.
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.