Performance issue because datasource being called multiple times
Posted: Mon Apr 22, 2024 2:20 pm
I have a dashboard with seven indicators. The value of each indicator is from the same datasource which executes a stored procedure.
In Preview mode the stored procedure is only being called once but in production the procedure is being called seven times, once for each indicator.
Identical data is returned every time.
Am I missing something?
Is there a way to ensure a datasource is only populated once?
In Preview mode the stored procedure is only being called once but in production the procedure is being called seven times, once for each indicator.
Identical data is returned every time.
Am I missing something?
Is there a way to ensure a datasource is only populated once?