kobotoolbox / kpi / 15586327183 / 1

81%

master: 76%

push

github

perf(submissions): move counter updates to the end of the transaction to minimize as much as possible row locking DEV-347 (#5813)

### 📣 Summary
Moved project counter updates to the end of the transaction to reduce
row-level locking and improve performance during submissions.

### 📖 Description
This change delays the update of submission-related counters (storage,
submission count, etc.) to the final part of the database transaction.
The goal is to avoid row-level locking in the middle of ongoing
operations, which can cause contention and slow down concurrent
requests.

By deferring these updates, we minimize locking time on counter rows,
especially under heavy write load.

6078 of 9695 branches covered (62.69%)

23072 of 28642 relevant lines covered (80.55%)

0.81 hits per line