Add column families (just try to be reasonable, like separating columns that is never modified to its own column family)
Add AS OF SYSTEM TIME '-30s' to read transactions to allow stale reads and hopefully improve throughput
Do SPLIT AT and SCATTER to split data ranges
Add retries -> write into retry_$i.txt for transactions that failed after 5 retries, and we retry those transactions after we finish running the entire experiment.
3. Set higher priority for delivery transactions as it is the most often to fail due to contention (probably because it is updating 3 tables at once 😢 )4. Use uuid as primary key in Orders table to more evenly spread out data (previously got TOO_OLD transaction)
Changes:
AS OF SYSTEM TIME '-30s'to read transactions to allow stale reads and hopefully improve throughputSPLIT ATandSCATTERto split data rangesretry_$i.txtfor transactions that failed after 5 retries, and we retry those transactions after we finish running the entire experiment.3. Set higher priority for delivery transactions as it is the most often to fail due to contention (probably because it is updating 3 tables at once 😢 )4. Use uuid as primary key in Orders table to more evenly spread out data (previously got TOO_OLD transaction)