kobotoolbox / kpi / 22866141556 / 1

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.

3383 of 11305 branches covered (29.92%)

17957 of 34398 relevant lines covered (52.2%)

0.52 hits per line