bcgov / cas-registration

A web app for Registration in OBPS under the Clean Growth branch
Apache License 2.0
1 stars 1 forks source link

Investigate and optimize ineffeciencies in backend /user-operator API routes #826

Open dleard opened 5 months ago

dleard commented 5 months ago

Blocked by #1062

The results of our load testing showed that we have some very ineffecient API routes in the /user-operator paths. We need to investigate the user-operator endpoints and optimize where necessary. Some really good exploration & optimization work has been done in #814, which will include documentation on the Django Silk endpoint profiler and some examples of how the GET /operations route was optimized.

AC:

Note: There's a double user lookup happening in some endpoints. More details here: https://github.com/orgs/bcgov/projects/122/views/2?filterQuery=user&pane=issue&itemId=59071266. Completing this card may also complete the linked card.

dleard commented 5 months ago

The least efficient endpoints: /user-operators and /user-operators/{id} have been optimized. The rest of the endpoints will need to be profiled & optimized if necessary

nanyangpro commented 4 months ago

This will be refined. @andrea-williams