|
|
While the 55 second headstart for the Mercedes and 24 seconds for the V8 saw all three vehicles cross the finishing line in short order, it turned out that the database shootout needed a bigger handicap.
An unspecified commercial database ("we can't actually say what it is because of the contract [which forbids the publication of comparative performance]," said John Ryan, Asia Pacific marketing manager at Ingres Australia) was given a 55 second handicap against Ingres VectorWise running the same query on the same data on identical hardware. VectorWise returned the result in less than one second, whereas 'brand X' took well over three minutes.
The test involved a 12GB database containing 72 million rows, based on the data from the DBT3 benchmark.
Jason Leonidas, vice president, Asia Pacific sales and services, explained that most DBMSes are generic and require a lot of tuning to suit any particular workload, whereas VectorWise is designed for excellent performance on ad hoc queries. It show that "what you should be using [in those situations] is a purpose-built database," ie VectorWise.
VectorWise promises rapid 'slicing and dicing' - see page 2.
