3 ms·
>SSD's should result in huge performance boosts, especially with nosql systems like MongoDB & CouchDB. This is entirely backwards. NoSQL solutions tend to trad
by ergo98 16y ago
>SSD's should result in huge performance boosts, especially with nosql systems like MongoDB & CouchDB.
This is entirely backwards. NoSQL solutions tend to trade space for reduced I/O, whereas a relational database trades I/O for reduced space.
- jbooth 16y agoNot 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.
- ergo98 16y agoI 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).