February 11, 2013 at 4:08 am
Hi,
I have worked fair bit on SSRS, however I have not implemented Caching of SSRS reports, ever.
Recently there are some reports which perform very slowly and I was wondering the possibility of implementing report caching.
What my understanding of report Caching is that report cache is created for each of the parameter values entered by a User. In my report ( the one which is slowly running), there are 10 parameters and out of those, 4-5 are those which have more than 10-12 distinct possible values and differently used by Users. If I enable report Caching in such a case, a cache copy would be created of the report for all the possible values selected by Users and there would be a lot of (50-60 may be more) copies of cache created. Is this overhead justified for good performance?
So my question is - "In such a case, will Caching help at all ?" OR Is it that "In multi-valued, multi-parameters report, Caching is not as helpful an option as it would be for reports with less or no parameters."
Regards,
Athar Iqbal
February 12, 2013 at 2:21 am
I am using SQL Server 2008 ( if that helps )
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply