I have a dashboard with nine widgets and they are all scattered plot running the same query which return a data frame which has about 14500 rows and 10 columns. The query takes 500 ms to run on the database but the dashboard is taking around 4 minutes to load.
I tried writing a separate query for each widget, so each query will only return the data needed for that particular plot which is about 14500 rows and 4 columns. I was able to drop the total dashboard loading time to about 2 minutes.
Any suggestion on how to further optimize the loading time for the dashboard?
Thank you very much.
- Redash Version: 8.0.0
- Browser/OS: Chrome (89.0.4389.90)
- How did you install Redash: Self-hoseted Redash on AWS