benchmarking-transaction-patterns
Guides benchmarking and comparing explicit multi-statement transactions versus single-statement CTE transactions in CockroachDB, with fair test methodology, contention analysis, and performance interpretation. Use when comparing transaction formulations, benchmarking CockroachDB workloads under contention, investigating retry pressure, or deciding whether to rewrite multi-step application flows into single SQL statements.
- Version
- 1.0
- Compatibility
- CockroachDB >= 22.1. Requires SQL access and a test cluster for benchmark execution. Do not run benchmarks against production workloads.
Pinned to revision 4e8964e24a5a, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/benchmarking-transaction-patterns/SKILL.md
- skills/benchmarking-transaction-patterns/cockroachdb-application-development/designing-application-transactions/SKILL.md
- skills/benchmarking-transaction-patterns/cockroachdb-query-and-schema-design/cockroachdb-sql/SKILL.md
Every link opens the file at its source, pinned to the revision this page describes.