Re: TPC-A and -B Benchmarks
Posted in 1993
Topics: Performance & Tuning
In-Reply-To: NLUNIX:rmy.emory.edu!ilist@sun4nl.nl.oracle.com's message of 07-07-93 16:08 |> As well explained by the Standish report, Oracle has effectively eliminated |> TPC-As as an effective comparison through their implementation of "discrete |> transactions" in Version 7, a feature that is clearly there for the sole |> purpose of improving TPC-A results (the nature of TPC-C eliminates their |> use). Irrespective of this, the industry has long known that TPC-As are |> woefully inadequate as a true measure of database performance. Their |> primary strength was in the number of results published. I do not agree, if you (and the people at Standish) had a good look at what discrete transactions are, you would certainly see some purpose for it, especially in OLTP kind of systems with a large number of simple transactions. The same is true for other kinds of functionality present in a lot of databases, like hashing. Hashing is of little use for most situations, but there are situations where this is very useful (TPC's is accidentally one of them). The rumour stated in a previous message that discrete transactions are only available in a special version of Oracle7 is completely untrue. It is a standard feature, completely documented. -- These opinions are just mine and not of Oracle Corporation Sandor Nieuwenhuijs Oracle Netherlands