TPC photo
The TPC defines transaction processing and database benchmarks and delivers trusted results to the industry
    Document Search         Member Login    
About the TPC
      Join the TPC
      Technical Articles

TPC-C is an on-line transaction processing benchmark.

The current TPC-C specification can be found on the TPC Documentation Webpage.

The current version of the TPC-C benchmark is Version 5.11. The TPC-C has continued to evolve its benchmarks to remain as representative of current practice as possible. The TPC-C benchmark continues to be a popular yardstick for comparing OLTP performance on various hardware and software configurations. For a short period after initial release of Version 5, upgrades from previous benchmark runs were allowed but required new Full Disclosure Reports and an auditor's review of the upgrade. Those results can be discerned in the table as having availability dates prior to the submitted dates.

Compared to the previous versions, pricing changes included reducing maintenance support pricing to 3 years down from 5 years, 24x7 maintenance up from 8x5, removing terminal network pricing (hubs, switches), and allowing pricing quotes from web pages and print materials. Runtime changes included reducing the disk space requirements to 60 days from 180 days, increasing the measurement interval to 2 hours up from 20 minutes, reporting checkpoint durations, and reporting the number of lost connections of users during the measurement interval. Because these revisions changed the price/performance metric and reporting requirements, Version 5 results may not be compared to results from earlier versions.
View Results
Approved in July of 1992, TPC Benchmark C is an on-line transaction processing (OLTP) benchmark. TPC-C is more complex than previous OLTP benchmarks such as TPC-A because of its multiple transaction types, more complex database and overall execution structure. TPC-C involves a mix of five concurrent transactions of different types and complexity either executed on-line or queued for deferred execution. The database is comprised of nine types of tables with a wide range of record and population sizes. TPC-C is measured in transactions per minute (tpmC).

TPC-C simulates a complete computing environment where a population of users executes transactions against a database. The benchmark is centered around the principal activities (transactions) of an order-entry environment. These transactions include entering and delivering orders, recording payments, checking the status of orders, and monitoring the level of stock at the warehouses. While the benchmark portrays the activity of a wholesale supplier, TPC-C is not limited to the activity of any particular business segment, but, rather represents any industry that must manage, sell, or distribute a product or service.
Overview Presentation
The following slide deck provides an overview of the TPC-C. The slides are based on a presentation at the May 1997 SIGMOD conference in Tuscon, Arizona, by Charles Levine of Microsoft and Jack Stephens of Informix. The presentations provide an overview of each benchmark's history, their market relevance, and the requirements for running the benchmarks, as well as a glimpse of future directions.

Valid XHTML 1.0 Transitional Valid CSS!