About DBT2 Benchmark Performance

A NuoDB implementation of the DBT2 benchmark performed as described below. By configuring NuoDB table partitions and storage groups (TP/SG) specifically for the DBT2 workload, this implementation achieved over one million New Order Transactions Per Minute (NOTPM) with 40 TEs and 10 SMs.

Partitioning the TPC-C schema is straightforward. There is a single, master, warehouse ID that most tables refer to. For all tables that reference a warehouse ID, the NuoDB implementation partitions by that key. The number of warehouses is divided by the number of TEs and there is one partition for each TE.

See also One Million NOTPM DBT2 Benchmark on NuoDB 2.3 on the NuoDB public blog.