Re:Superfast SSDs are coming, but will they be used the righ...
by jbooth on Friday October 29, 2010 @10:22AM
(#1847390)
Not really. Both systems wind up IO-bound very quickly if you're out of memory. NoSQL systems might get to a higher number of requests/second before flatlining, but they're still fundamentally disk bound unless your dataset fits in memory.
Re:Superfast SSDs are coming, but will they be used the righ...
by ergo98 on Friday October 29, 2010 @10:32AM
(#1847414)
I was specifically replying to the "especially" bit. The net benefit of an SSD is far less pronounced with many NoSQL solutions (in particular document stores) than with relational databases. That's because the former was built and adopted largely to make lemonade out of the I/O problem (particularly on terrible I/O platforms like AWS).
This is entirely backwards. NoSQL solutions tend to trade space for reduced I/O, whereas a relational database trades I/O for reduced space.