Caching SSRS Reports having multiple Parameters.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » Caching SSRS Reports having multiple...

Caching SSRS Reports having multiple Parameters.

Rate Topic

Display Mode

Topic Options

Author

Message

syedathariqbal

Posted Monday, February 11, 2013 4:08 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 7:35 AM
Points: 81, Visits: 335

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

syedathariqbal

Posted Tuesday, February 12, 2013 2:21 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 7:35 AM
Points: 81, Visits: 335

I am using SQL Server 2008 ( if that helps )

Post #1418810

« Prev Topic | Next Topic »

Permissions