Performance Comparison

What is TPCC?

TPC Benchmark™ C (TPC-C) is an Online Transaction Processing (OLTP) benchmark, which measures the performance of transaction processing systems. It is a mixture of read-only and update-intensive transactions that simulate the activities found in complex OLTP application environments. This is done by exercising a breadth of system components associated with such environments, which are characterized by:

The simultaneous execution of multiple transaction types that span a breadth of complexity
On-line and deferred transaction execution modes
Multiple on-line terminal sessions
Moderate system and application execution time
Significant disk input/output
Transaction integrity (ACID properties)
Non-uniform distribution of data access through primary and secondary keys
Databases consisting of many tables with a wide variety of sizes, attributes, and relationships
Contention on data access and update

The performance metric reported by TPC-C is a "business throughput" measuring the number of orders processed per minute. Multiple transactions are used to simulate the business activity of processing an order and each transaction is subject to a response time constraint. The performance metric for this benchmark is expressed in transactions-per-minute-C (tpmC). To be compliant with the TPC-C standard, all references to tpmC results must include the tpmC rate, the associated price-per-tpmC, and the availability date of the priced configuration.

The TPC-C is a popular yardstick for comparing OLTP performance on various hardware and software configurations. Using TPC-C based benchmark, we compared the performance of Daffodil DB with other popular database servers on the following System Configuration:

System Configuration
Processor	p-4 1.7 GHz
RAM	512 MB
HDD	40 GB
OS	Windows2000
JDK Version	J2sdk1.4.2

The test results were as follows:

	Daffodil DB	Mysql 4.0	Mysql 5.0	PostgreSQL
Version	4.0	4.1.1	5.0.3	8ric
Mode	Network	Network	Network	Network
Time Duration	2 Hrs	2 hrs	2 hrs	2 Hrs
TOTAL Time For Execution Transaction	7201 sec	7201 sec	7201 sec	7210 sec
TPMC Result	131 Transactions /Min	560.74 Transactions /Min	483.95 Transactions /Min	62 Transactions /Min

Disclaimer : These results have been reflected in the internal tests conducted by Daffodil Software. The views expressed in this section and the information made available is purely that of Daffodil Software. Daffodil Software does not hold any responsibility or liability for any damage that may occur by using directly or indirectly any test results.