Improving the application performance - Using Variable
I have a query wrt using variable.
If a expression is used more than one time in a chart with a different condition, in this scenario if we remove the expression with variable and use it several time, will it improve the performance/decrease the calc time?
Actually, I just did the same - expression was too huge and used twice with different condition. So, I created variable and replaced in both the place. Likewise there was several expression repeated and I did the same for all.
But instead of decreasing the CALC time of the object it increased. Before replacing with variable it was 1700 ms and after replacing with variable it got increased to 8075 ms.
PLEASE help in understanding where I am going wrong?