kobotoolbox / kpi / 23445335551

82%

master: 76%

push

github

 perf(permissions): speed up bulk permission assignments DEV-421 (#6812)

### 📣 Summary

Assigning permissions to many users at once was extremely slow because
each user triggered a separate round-trip to the database for every
permission it received.

### 📖 Description

When sharing a survey or collection with a large number of users through
the bulk permission endpoint, the server would perform one database
write per user per permission — including implied permissions. On
datasets of 100+ users this caused noticeable slowdowns and, at scale,
timeouts.

All writes are now batched into a small fixed number of queries
regardless of how many users are in the payload. Removals are similarly
batched where possible. The API contract and visible behaviour are
unchanged.

7685 of 11869 branches covered (64.75%)

22 of 115 new or added lines in 2 files covered. (19.13%)

29343 of 35758 relevant lines covered (82.06%)

5.8 hits per line