kobotoolbox / kpi / 15586327183

81%

master: 76%

Build Type

push

github

Committed by web-flow

Commit Message

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.

Run Details

6078 of 9695 branches covered (62.69%)

82 of 86 new or added lines in 5 files covered. (95.35%)

3 existing lines in 1 file now uncovered.

23072 of 28642 relevant lines covered (80.55%)

0.81 hits per line