What database would you use to store (min) 10 billion objects?

Re:What database would you use to store (min) 10 billion obj... by ntoshev on Friday May 08, 2009 @03:55AM (#599342)

You realize these numbers are not for transactional (ACID) updates, right? They are with write cache enabled, meaning a power failure would cause data reported as written not to be available. I hope it doesn't mean data corruption, if someone has tested this I'd like to hear from them.

For ACID storage, one transaction per disk rotation is pretty much a theoretical limit for sustained performance.

[ Parent | on HN ]

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.

[ Parent | on HN ]