kobotoolbox / kpi / 22866141556 / 9

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.

5210 of 11425 branches covered (45.6%)

23198 of 34488 relevant lines covered (67.26%)

0.67 hits per line