kobotoolbox / kpi / 22866141556 / 3

81%

master: 76%

push

github

perf(assets): reduce memory and query overhead in permission loading DEV-1803 (#6790)

### 📣 Summary
Loading asset lists was slow and memory-hungry for accounts with many
projects and shared users. This PR makes it significantly faster and
lighter.

### 📖 Description
The asset list was doing a lot of redundant database work behind the
scenes — fetching the same permission data over and over for each asset.
This PR fixes that by loading what's needed up front, in as few queries
as possible.

A new optional query parameter `?current_user_permissions_only=true`
lets the frontend request only the current user's own permissions,
instead of everyone's. The frontend now sends this automatically on
every asset list call, which makes a noticeable difference on accounts
with lots of sharing.

3473 of 11309 branches covered (30.71%)

18400 of 34405 relevant lines covered (53.48%)

0.53 hits per line