databasessystem-design
When should a database transaction be short?
Anonymous
Keep a transaction focused on the state changes that must commit together. Long transactions can hold locks or snapshots longer, increasing contention and resource use depending on the database. Avoid waiting on external network calls inside one when possible; do that work before or after with a recovery plan.
0