TPC-C Transactions
New-Order
- Get records describing a warehouse, customer, & district
- Update the district
- Increment next available order number
- Insert record into Order and New-Order tables
- For 5-15 items, get Item record, get/update Stock record
- Insert Order-Line Record
Payment, Order-Status, Delivery, Stock-Level have similar complexity, with different frequencies
tpmC = number of New-Order transaction per min.