Dashboard Performance - How to speed up reports loading on dashboard
We are using a dashboard with multiple graphs/reports for KPI reporting. The view used by these reports is cached within Yellowfin. We find that the load times for each report are quite long (+/- 5 secs per graph) and reports are loaded sequentially, meaning that each page of the dashboard takes more than 30 seconds to load. We feel that that is too slow for an end-user facing report, esp. with all the data already sitting within Yellowfin.
Branch Report is not used and does not seem approprate because each graph has a different filter. Reason for this is that we want to use the filter in the name of the title in the Design.
Even if we don't change the filters and go from one Subtab to another all graphs are refreshed.
Do you have any guidance on how to improve the performance here? Is it possible to allow multiple graphs to load at the same time in a dashboard?
Our environment consists of a single container (database is hosted separately), where the container has 4 CPU available, and 15GB of RAM (of which max. 10GB is available as JVM)