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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
