2. What is the TPC and TPC-C?

2. What is the TPC and TPC-C?

Designing and implementing a database benchmark is a significant challenge. Many performance tests and tools experience difficulties in comparing system performance especially in the area of scalability, the ability of a test conducted on a certain system and schema size to be comparable with a test on a larger scale system. When system vendors wish to publish benchmark information about database performance they have long had to access to such sophisticated test specifications to do so and the TPC is the industry body most widely recognized for defining benchmarks in the database industry recognized by all of the leading database vendors. TPC-C is the benchmark published by the TPC for Online Transaction Processing and you can view the published TPC-C results at the TPC website.

As defined by the TPC "TPC benchmarks are industry standards. The TPC, at no charge, distributes its benchmark specifications to the public." For this reason HammerDB includes an implementation of the specification of the TPC-C benchmark that can be run in supported database environments. Implementing the TPC-C specification has the significant advantage that you know that the test is reliable, scalable and tested to produce accurate, repeatable and consistent results.

The TPC published an additional benchmark specification for transactional systems called TPC-E introduced in February 2007. However unlike TPC-C this benchmark has not been widely adopted by all of the commercial database vendors.