I need a Help from anyone.
I developed a Report which has 13 Data providers, In order to Refresh this Report BO is Taking almost 10 to 15mins approximately. Which is not Considerable.
I Guess this is due to the more no. of Data providers. How many data providers we have those many times BO need to hit the Database, This will impact the report performance.
But my Problem here is i tried to Reduce the no.of Data providers unfortunately i couldn’t.
Can anyone help me how to improve the performance in order to reduce the Refresh time.
Any advice is very help full to me friends. at least to give a light to proceed.