How does transparency affect TPC-C?
- Payment txn: 15% of Customer table records are non-local to the home warehouse.
- New-order txn: 1% of Stock table records are non-local to the home warehouse.
In a distributed cluster, the cross warehouse traffic causes cross node traffic and either 2 phase commit, distributed lock management, or both.
For example, with distributed txns:
Number of nodes % Network Txns