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

Improve performance of database queries #76

Open
jpwahle opened this issue Jul 15, 2022 · 2 comments
Open

Improve performance of database queries #76

jpwahle opened this issue Jul 15, 2022 · 2 comments
Assignees
Labels
perf Pull Request: Performance increases

Comments

@jpwahle
Copy link
Owner

jpwahle commented Jul 15, 2022

This ticket aims to improve database access times by orders of magnitude by using indexes and efficient query design.

The ticket has some sub-issues to make migration in production easier.

  1. Extend database schemas #90
  2. Add caching to preRead, preUpdate, preCreate middleware. #91
  3. Merge controllers of frontend with existing CRUD endpoints. #73
@jpwahle jpwahle created this issue from a note in cs-insights (Todo) Jul 15, 2022
@jpwahle
Copy link
Owner Author

jpwahle commented Jul 15, 2022

The filters are now almost instantaneous and the tool now more responsive in general #75.
The /quartiles functions are much improved too #74.

Still when quering without filters, the "worst case" is only better for /quartiles yet.
Other routes need to be made more efficient.

@jpwahle jpwahle added the perf Pull Request: Performance increases label Jul 15, 2022
@trannel
Copy link
Contributor

trannel commented Jul 18, 2022

Related to or duplicate of #25

@jpwahle jpwahle moved this from Todo to Near Future in cs-insights Aug 12, 2022
@jpwahle jpwahle moved this from Near Future to Todo in cs-insights Aug 17, 2022
@jpwahle jpwahle moved this from Todo to Near Future in cs-insights Aug 22, 2022
@jpwahle jpwahle moved this from Near Future to Backlog in cs-insights Sep 12, 2022
@jpwahle jpwahle removed this from Backlog in cs-insights Oct 12, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
perf Pull Request: Performance increases
Projects
Status: 🔖 Ready
Development

No branches or pull requests

3 participants