Sybase leads three out of five large database benchmark categories with the Transaction Processing Performance Council (TPC), with the key criteria being price/performance.
The TPC is a non-profit organisation recording objective, verifiable transaction processing and database benchmarks for the industry.
"Sybase IQ 12.5 leads the 100GB, 300GB and 1 000GB categories with the lowest cost to performance ratio. We have only entered three of the five categories, starting at the bottom and working our way up," says Estelle de Beer, BI product manager at Sybase SA. "Our international head office has confirmed that we will soon be entering the remaining two categories for 3 000GB and 10 000GB databases."
The performance metric reported by TPC-H is called the TPC-H Composite Query-per-Hour Performance Metric (QphH@Size). In the 100GB database category Sybase came in at $23 price/QphH, rising to only $27 price/QphH in the 300GB database category and reaching $104 price/QphH in the 1 000GB database category.
Testing was done on Sun equipment, a SunFire V250 in the 100GB and 300GB categories, with two 1.28GHz processors, 8GB of memory and two 73GB hard disks.
The 1 000GB database test was performed on a SunFire V880, with eight 1050MHz processors, 32GB of memory and six 73GB hard disks.
"It is only in the very large companies that you find raw data in excess of 1TB in SA, so the fact that Sybase leads in these categories in terms of price versus performance, from 100GB to 1 000GB, means that we have effectively addressed one of the primary concerns of the majority of local organisations," says De Beer.
Total cost for the 100GB system was $33 495, for the 300GB system it was $34 600 and for the 1 000GB system it was $232 206.
The TPC-H benchmark consists of a suite of business-oriented ad hoc queries and concurrent data modifications. The queries and the data populating the databases have been chosen to have industry-wide relevance and the benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity and give answers to critical business questions.
Share
