[wazo-confd] user routes are slow

Description

Because the user objects has too many relationships, loading it (or multiple) takes a long time without proper planning (loading strategy).

By tweaking the loading strategy and which relationships to load, we can drastically lower the time it takes to fetch the entries

Zendesk Ticket IDs

None

Activity

Show:

Julien Alie June 28, 2023 at 2:52 PM
Edited

One problematic relationship is due to call permissions. Specifically introduced in
Loading strategy should never be declared on relationships, only at query level. The side effect is call permissions will load too many unneeded objects, wasting resources

The fix will be to revert the commit and implement the eagerloading directly in callpermission query instead of relationship

Done

Details

Priority

Assignee

Reporter

Fix versions

Sprint

Zendesk Support

Created June 16, 2023 at 3:32 PM
Updated July 19, 2023 at 11:14 AM
Resolved July 12, 2023 at 2:20 PM