France-ioi / AlgoreaBackend

Backend for the new Algorea platform
MIT License
1 stars 2 forks source link

`items propagation` and `groups propagation` step by step transactions #1064

Closed GeoffreyHuck closed 3 months ago

GeoffreyHuck commented 3 months ago

For now in the worst case, the items propagation took ~6s. Since the process acquires a lot of write locks, it makes other select queries for other services wait for this amount of time. This doesn't fully solve the waiting problem though. It just makes the wait faster because the transactions are now smaller. The code is a bit weird because we still have two cases where the group propagation have to be executed inside a bigger transaction:

codecov[bot] commented 3 months ago

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 100.00%. Comparing base (1393a31) to head (073cb2a). Report is 2 commits behind head on master.

Additional details and impacted files ```diff @@ Coverage Diff @@ ## master #1064 +/- ## ========================================= Coverage 100.00% 100.00% ========================================= Files 236 236 Lines 14254 14260 +6 ========================================= + Hits 14254 14260 +6 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.