Re: validation testing -- use TPC-C? (or what?)

"Larry Menard" <root_at_GoSpamYourself.com> wrote in message news:ToqdnbsTUv7FYgPenZ2dnUVZ_t-dnZ2d_at_rogers.com...
> My TPC knowledge is a bit dated, so take it with a grain of salt.
>
> First of all, make sure you are looking for the right benchmark for the
> type of processing you are interested in. For example, TPC-C is a
> benchmark that is indicative primarily of rapid transaction processing.
> There are other benchmarks for workloads that are more DSS-intensive
> (TPC-H or TPC-D) or web-intensive (TPC-W).
>
> Second, I don't know of any publicly available TPC-C kits. It is my
> understanding that the source code used for TPC-C benchmark applications
> are closely-guarded secrets, since the application code itself might
> contain code that accounts for significant performance improvements.
> --
> --------------------
> Larry Menard
> "Defender of Geese and of All Things Natural"
>

The TPC benchmarks are published at www.tpc.org

I have reproduced the TPC-H (decision support) benchmark and the tpc.org site provides you with everything you will need, including the test data generator program. You may find it a bit difficult to compile the test data generator program successfully, but I was able to get it to work after changing a few compile parms. They also supply the schema and queries. You will want to look at the vendor docs for each benchmark to pick up any customization they have done to queries to allow for slight variations in SQL syntax between the databases.

The TPC-C OLTP benchmark may be harder to reproduce as mentioned above, but details of the benchmarks are published by each vendor on the website so you could look there. Received on Tue Dec 13 2005 - 12:51:01 CST