News for hackers. Stuff that matters.
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.