Re: Tip: Your next XRaid may be an SSD
Re: Tip: Your next XRaid may be an SSD
- Subject: Re: Tip: Your next XRaid may be an SSD
- From: Guido Neitzer <email@hidden>
- Date: Mon, 15 Dec 2008 17:10:13 -0700
On 15.12.2008, at 15:27, Miguel Arroz wrote:
Excellent email! I've been arguing for some time now that SSD is the
way to go for DBs, it's good that some real evidence is showing up.
Seek time kills DBs. :)
There is some evidence showing up, true, but it also probably shows
bad cache strategies or usage patterns resulting in bad hit rate on
the cache.
If a change from HD to SSD results in a 40x increase in query
performance, something seems to be badly wrong with what the database
does - or the usage pattern and / or the database setup is not optimal.
It also might be a case where FrontBase hits some bad walls due to
what it does while other databases will be not nearly as badly
effected. For example lots of inserts into large tables with a couple
indexes plain kills FrontBase performance (at least up to version 4.x).
So, these values might be valid for FrontBase, but need a careful look
where the real gain is coming from as a fast RAID (I'm not talking
about XserveRAID obviously) combined with a working cache will deliver
a very high performance, too. Especially when writing to the disks.
Most server manufacturares will be able to sell you servers and
storage with 2.5" bays. I don't know if they predicted the obvious,
or if it's just for power, heat dissipation and density purposes,
but some people are already using 2.5" drives on their servers.
E.g.:
http://www.infortrend.com/main/2_product/es_b12s-r(g)1030.asp
cug
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden