Re:Superfast SSDs are coming, but will they be used the righ...
by dutchbrit on Friday October 29, 2010 @07:30AM
(#1846901)
SSD's should result in huge performance boosts, especially with nosql systems like MongoDB & CouchDB. Can't wait until the prices start to drop!
[ Parent
| on HN ]
Re:Superfast SSDs are coming, but will they be used the righ...
by Nate75Sanders on Friday October 29, 2010 @08:16AM
(#1847002)
I would have thought the biggest performance boost would have come for databases based on B-tree-like structures on large datasets.
You have to read to read and read to write. Every depth of the tree that doesn't fit into main memory costs you a random read, whether to read or write.
Re:Superfast SSDs are coming, but will they be used the righ...
by jbellis on Friday October 29, 2010 @09:51AM
(#1847296)
Write amplification (http://en.wikipedia.org/wiki/Write_amplification) means that naive random writes like what you see from b-trees are going to degrade performance on SSDs too (although not as pathologically as doing rotational seeks). In other words it still pays to be smart about i/o patterns.
Re:Superfast SSDs are coming, but will they be used the righ...
by eru on Friday October 29, 2010 @02:58PM
(#1848507)
Shouldn't you be able to do mostly sequential writes if you have a b-tree structure and a copy-on-write filesystem (like btrfs)?
Re:Superfast SSDs are coming, but will they be used the righ...
by eru on Sunday October 31, 2010 @09:46AM
(#1853226)
Plus the occasional GC. But you can do this while idle.
Re:Superfast SSDs are coming, but will they be used the righ...
by ergo98 on Friday October 29, 2010 @09:22AM
(#1847195)
>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.
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).