Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Optimize (and fix) /manage/statistics queries #3798

Open
4 tasks
willgearty opened this issue Jan 7, 2025 · 0 comments
Open
4 tasks

Optimize (and fix) /manage/statistics queries #3798

willgearty opened this issue Jan 7, 2025 · 0 comments

Comments

@willgearty
Copy link
Member

willgearty commented Jan 7, 2025

Many of the queries on the /manage/statistics result in errors or take a long time. I'm guessing we aren't being nearly as optimal as we could be for some of the DB queries that we make. We should do the following:

  • Test existing queries to see which ones don't work
  • Check the code for the existing queries and make sure they are as optimal as possible (only grab the data we actually need)
  • Add paging if we are going over a large number of programs
  • Add caching, if possible (to improve loading of the page during periods of stasis)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants