rcpch / rcpch-audit-engine

Epilepsy12 Audit Platform
https://e12.rcpch.ac.uk/
GNU Affero General Public License v3.0
5 stars 5 forks source link

Slow page load on organisation summary #1092

Open mbarton opened 4 weeks ago

mbarton commented 4 weeks ago

In production: ~3s Local dev: 1.5s

We need to profile and see which queries are slow on this page. It shouldn't be KPIs as they are still updated at write time. It will inevitably be slower in production as the DB is now in a separate instance but we can probably reduce the overhead by changing CONN_MAX_AGE from the default (new connection every request).