Refactor CO's overview, ORG overview and Service overview to fetch only the data shown in the tables to improve performance - Githubissues

SURFscz / SBS

Samenwerking Beheer Systeem ↣ Collaboration Management System

Apache License 2.0

3 stars 2 forks source link

Refactor CO's overview, ORG overview and Service overview to fetch only the data shown in the tables to improve performance #1355

Open oharsta opened 2 months ago

oharsta commented 2 months ago

Currently we are fetching the data using the SQLAlchemy objects and queries which fetch everything. Write custom queries and only fetch the data actually shown in the overview.

FlorisFokkinga commented 2 months ago

Some slower pages are:

Connected colaboration for services with ~1000 collaborations (https://sram.surf.nl/services/##/collaborations)
Collaborations for organisations with ~750 collaborations (https://sram.surf.nl/organisations/##/collaborations)
Services tab for collaborations with ~40 available services (https://sram.surf.nl/collaborations/##/services)
History for organisation with a lot of activity (https://sram.surf.nl/audit-logs/organisations/##)

Optionally, for platform admins

The collaborations tab with ~2500 collaborations (https://sram.surf.nl/home/collaborations)
The services tab with ~150 services (https://sram.surf.nl/home/services)