kobotoolbox / kpi / 22866141556

81%

master: 76%

Build Type

push

github

Committed by web-flow

Commit Message

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.

Run Details

7278 of 11443 branches covered (63.6%)

70 of 108 new or added lines in 6 files covered. (64.81%)

3 existing lines in 1 file now uncovered.

27987 of 34488 relevant lines covered (81.15%)

5.74 hits per line