Flash technology based HDD will it make significant difference for OLTP applications?

From: Jurijs Velikanovs <j.velikanovs_at_gmail.com>
Date: Sun, 6 Jan 2008 23:34:41 +0200
Message-ID: <d6f0def50801061334y6d0cb1dq4c54bd01b1b091f4@mail.gmail.com>


Hello everyone and Happy new year to you,

Just wonder if you can give your advice if the devices as following will make any difference in the context for Oracle RDBMS performance in the nearest time?
http://www.sandisk.com/OEM/ProductCatalog(1331)-SSD_Ultra320_Wide_SCSI_35.aspx

From my point of view:
- "Access time <0.02 ms" at least 30 times faster then today's HDD-s
capable to achieve.It gives significant improvement for some profile Physical IO-s.
- Current price 5k for 300GB might be acceptable for some systems even
today. This parameter will go down within 1-2 years significantly.
- Max read/write operation count is limited. In spite of that to use
first point some organizations might choose to change HDD on regular basis (once a year/months) to improve throughput for some applications
- It will not solve all problems but introduce significant
improvements in some areas.

PS I am sorry if this topic has been discussed already, please point me to the thread then.

Thank you in advance,
Jurijs

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jan 06 2008 - 15:34:41 CST

Original text of this message