A recent test has shown that decision support queries are faster and cheaper with Fusion-io and Dell, but only up to a point. The pair produced a top three database query benchmark result against the TPC-H standard. We're used to flashy and eye-catching million IOPS demos from Fusion-io and the likes of HP and IBM, to show off …
Let's get real here. TPC-H is a read-only workload -- this should have been a home-run for Flash SSD, since the benchmark barely ever writes anything. So, according to the conventional "wisdom" around Flash SSD, this system should have been vastly CHEAPER than HDD systems in terms of dollars-per-query-per-hour, yet it's not. It's more expensive. It was beaten by CHEAPER systems based on mechanical HDD and open-source my-SQL.
Time to take a break from the SSD Kool-Aid?