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鈥檒l occasionally send you account related emails.

Already on GitHub? Sign in to your account

Work on SQL for dashboard #3409

Open
1 of 3 tasks
fabianraf opened this issue Dec 13, 2023 · 0 comments
Open
1 of 3 tasks

Work on SQL for dashboard #3409

fabianraf opened this issue Dec 13, 2023 · 0 comments
Assignees

Comments

@fabianraf
Copy link
Contributor

fabianraf commented Dec 13, 2023

馃憠馃徏 Steps to Reproduce

  1. Go to Dashboard in production
  2. Notice how slow the site is

馃嚭馃嚫 States this bug is happening in

  • ALL
  • Nebraska
  • Illinois

馃ДExpected behavior

There should be a SQL statement that brings all the information needed for x state.

馃彄 Implementation Details

The permanent solution consist on bringing the dashboard information as a unique query against database where it builds all the values that the dashboard needs to show. The current implementation is very inefficient due to repetitive queries that occur in a nested format.

@fabianraf fabianraf self-assigned this Dec 13, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: In Progress
Development

No branches or pull requests

1 participant