Feeds

Fusion-io flush with flash success after demo

Only beaten by expensive, exotic and dedicated kit

Internet Security Threat Report 2014

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 the performance of its ioDrive, a PCI-e-connected flash solid state drive (SSD). This Dell result is more down to earth and is set in the world of business intelligence.

The TPC-H benchmark from the Transaction Processing Performance Council was used, and measures the number of decision support database transactions per hour against a set database size: 100GB in this case. The benchmark provides a variety of measures, the headline ones being the transactions per hour, the system cost, and the cost per transaction.

Dell and Fusion-io ran with Microsoft's SQL database, a dual quad-core Xeon server, four 80GB ioDrives and eight 73GB 15,000rpm SAS drives. The system recorded 28,772 QphH (TPC-H Queries-per-Hour) at a cost of $1.46 per query. The total system cost was $41,998.

Other systems did better, scoring a higher number of QphH, but only two recorded cheaper costs per transaction. The traditional way of getting high results is to throw spindles and cores at the database. The two better results used clustering in one case and an HW-accelerated query module in the other.

CPI scored a massively larger 209,298.9 QphH at an individual transaction cost of $1.25. But it needed a cluster of 12 dual quad-core Xeons, each with two 10,000rpm SATA drives, at a total system cost of $261,623 to get there. This is very much in exotic, dedicated technology territory.

KickFire recorded a result which was both faster and cheaper than Dell and Fusion-io's. Its configuration used a dedicated SQL query hardware appliance, twinned with a pair of quad-core Xeon servers and eight 15,00rpm SAS drives. This set-up recorded 49,229 QphH, at a cost of $0.70 per transaction and a total system cost of $34,425.

Fusion-io stresses that its Dell-based result used Microsoft SQL software, not open source software, and was COTS-based, using commercial, off-the-shelf components. What it's saying is that, if you want to add decision support work to an industry-standard server, and just need the ability to churn through a limited amount of work quickly without using specialised hardware or software, then the ioDrive will do the job for you.

Alternatively, if you want a dedicated box with better performance, lower acquisition and per-transaction costs, then kick decision support ass with KickFire. If you want screaming 200,000-plus QphH performance and have almost a quarter of a million dollars to spend then the CPI cluster is the thing to go for. You can delve more into the results here. ®

Beginner's guide to SSL certificates

More from The Register

next story
Docker's app containers are coming to Windows Server, says Microsoft
MS chases app deployment speeds already enjoyed by Linux devs
'Hmm, why CAN'T I run a water pipe through that rack of media servers?'
Leaving Las Vegas for Armenia kludging and Dubai dune bashing
'Urika': Cray unveils new 1,500-core big data crunching monster
6TB of DRAM, 38TB of SSD flash and 120TB of disk storage
Facebook slurps 'paste sites' for STOLEN passwords, sprinkles on hash and salt
Zuck's ad empire DOESN'T see details in plain text. Phew!
SDI wars: WTF is software defined infrastructure?
This time we play for ALL the marbles
Windows 10: Forget Cloudobile, put Security and Privacy First
But - dammit - It would be insane to say 'don't collect, because NSA'
Oracle hires former SAP exec for cloudy push
'We know Larry said cloud was gibberish, and insane, and idiotic, but...'
Symantec backs out of Backup Exec: Plans to can appliance in Jan
Will still provide support to existing customers
prev story

Whitepapers

Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Why cloud backup?
Combining the latest advancements in disk-based backup with secure, integrated, cloud technologies offer organizations fast and assured recovery of their critical enterprise data.
Win a year’s supply of chocolate
There is no techie angle to this competition so we're not going to pretend there is, but everyone loves chocolate so who cares.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Intelligent flash storage arrays
Tegile Intelligent Storage Arrays with IntelliFlash helps IT boost storage utilization and effciency while delivering unmatched storage savings and performance.