Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Caching SSRS Reports having multiple Parameters. Expand / Collapse
Author
Message
Posted Monday, February 11, 2013 4:08 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 7, 2014 7:17 AM
Points: 108, Visits: 448
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
Post #1418303
Posted Tuesday, February 12, 2013 2:21 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 7, 2014 7:17 AM
Points: 108, Visits: 448
I am using SQL Server 2008 ( if that helps )
Post #1418810
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse