BM Seer Unofficial thoughts from an anonymous Sun employee

TPC-E New OLTP benchmark - how does it stack up?

Monday Feb 26, 2007

Now that TPC-E is an official benchmark we can look at the public documentation at http://www.tpc.org/tpce/default.asp to start to compare it with the overly-simplistic TPC-C benchmark.

Characteristic TPC-E TPC-C
Age: New! very old: 14 years
Benchmark: OTLP database OTLP database
#tables: 33 9
#transaction: 10 mixed 5 lightweight
hyperoptimize-able?: new, too early to tell IBM over-optimised

TPC has seemed to make some headway on this workload. We'll have to see how useful it is to judging real-world performance. At least this is a step in the right direction.

More info at www.tpc.org.

[2] Comments
Like this post? del.icio.us | furl | slashdot | technorati | digg
Posted at 10:17AM Feb 26, 2007 in Benchmarks
Tags:
Comments:

Why only 33 tables ?

Posted by przemol on February 27, 2007 at 03:02 AM PST #

I'm not involved with the TPC-E design effort so I can't tell you their reasoning. I'll admit it I am a bit disappointed that there aren't a lot more tables and transactions. I worry that some of the same gaming that happened with IBM's TPC-C optimisations (that their IBM fellow admitted that he couldn't do if it was a real complex workload). As this information gets out hopefully TPC can make rules to keep it realistic.

Posted by BM Seer on February 27, 2007 at 02:11 PM PST #

Post a Comment:
Comments are closed for this entry.