On 3/17/06, Luke Lonergan <llonergan@xxxxxxxxxxxxx> wrote: > > Now what happens as soon as you start doing random I/O? :) > If you are accessing 3 rows at a time from among billions, the problem you > have is mostly access time - so an SSD might be very good for some OLTP > applications. However - the idea of putting Terabytes of data into an SSD > through a thin straw of a channel is silly. I'll 'byte' on this..right now the price for gigabyte of ddr ram is hovering around 60$/gigabyte. If you conveniently leave aside the problem of making ddr ram fault tolerant vs making disks tolerant, you are getting 10 orders of magnitude faster seek time and unlimited bandwidth...at least from the physical device. While SANs are getting cheaper they are still fairly expensive at 1-5$/gigabyte depending on various factors. You can do the same tricks on SSD storage as with disks. SSD storage is 1-2k$/gigabyte currently, but I think there is huge room to maneuver price-wise after the major players recoup their investments and market forces kick in. IMO this process is already in play and the next cycle of hardware upgrades in the enterprise will be updating critical servers with SSD storage. Im guessing by as early 2010 a significant percentage of enterpise storage will be SSD of some flavor. merlin
