This isn't an extrapolatable data point, but we installed Intel "mainstream"
SSDs (Flash based drives - 250MB/s reads, 70MB/s writes) in several customer
machines. They were complaining about a query that pulls customer history
for multiple sites and multiple years (basically pulling tiny slivers of
data from random database pages in a 10GB+ file). It was taking 10-20
seconds for some customers - too long to wait for a sale transaction to
start.



The SSD sped up the query by a factor of more than 10. Not bad for a $350
upgrade.



From: Firebird-general@yahoogroups.com
[mailto:Firebird-general@yahoogroups.com] On Behalf Of Alexandre Benson
Smith
Sent: Thursday, September 10, 2009 09:08 PM
To: Firebird-general@yahoogroups.com
Subject: Re: [Firebird-general] Re: Support for Tablespaces/Data-placement
in Firebird?





I have my doubts about put indices, data and temp on separated disks.

Let's suppose you are running a query that needs to read the data disk
intensively, the 2 other disks will be "idle".

If you create a RAID and put everything on the same volume, you will
always use the total bandwidth, no matter what kind of query you are
running. I think this case you will always have the best performance.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br





[Non-text portions of this message have been removed]