Page 1 of 1

Performance issue because datasource being called multiple times

Posted: Mon Apr 22, 2024 2:20 pm
by tinytimtwo
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?

Re: Performance issue because datasource being called multiple times

Posted: Mon Apr 22, 2024 8:02 pm
by Lech Kulikowski
Hello,

What product, viewer and version are you use?

Thank you.

Re: Performance issue because datasource being called multiple times

Posted: Thu Apr 25, 2024 4:03 pm
by tinytimtwo
Hi,

I am using web.NetCore.
I was on version 2023.4.1 but have since upgraded to 2024.2.4 & that has alleviated the issue.
I have discovered though that calculated columns still seem to cause the datasource proc to be called multiple times; I resolved this by moving the calculated columns into my proc.

thanks
Tim

Re: Performance issue because datasource being called multiple times

Posted: Fri Apr 26, 2024 8:21 am
by Lech Kulikowski
Hello Tim,

Thank you for the information.