Re:Flash Drives Replace Disks at Amazon, Facebook, Dropbox
by PaulHoule on Wednesday June 13, 2012 @04:01PM
(#4108111)
The economic crossover for HDD, SDD and distributed main-memory database depends on data volume vs. query volume.
SSD and DMRD win when the query volume is high compared to the data volume since with HDD you'll need to build multiple copies of the system (or equivalent) to handle the load, whereas SSD and DMRD serve more queries with less hardware.
On the other hand, in cases where query volume is low, HDD is cheaper. But if time-to-market matters, you really do want to reduce the turnaround time for your batch jobs and exploratory queries because in the development of KB's with a subjective element you'll probably need to throw 10-100 things at the wall to get the one that sticks.
SSD and DMRD win when the query volume is high compared to the data volume since with HDD you'll need to build multiple copies of the system (or equivalent) to handle the load, whereas SSD and DMRD serve more queries with less hardware.
On the other hand, in cases where query volume is low, HDD is cheaper. But if time-to-market matters, you really do want to reduce the turnaround time for your batch jobs and exploratory queries because in the development of KB's with a subjective element you'll probably need to throw 10-100 things at the wall to get the one that sticks.