search

jpwahle / cs-insights-backend

API server of the cs-insights project. This is the main part of storing data and accessing an external data analysis endpoint. It uses a mongoDB instance to store everything and queries the cs-insights-prediction-endpoint to get machine learning results.
https://jpwahle.github.io/cs-insights-backend/
MIT License
7 stars 0 forks source link

Improve performance of database queries #76

Open jpwahle opened 2 years ago

jpwahle commented 2 years ago

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. 90

  2. 91

  3. 73

jpwahle commented 2 years ago

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.

trannel commented 2 years ago

Related to or duplicate of https://github.com/gipplab/cs-insights-backend/issues/25