CODEDIGEST
Home » Articles
Search
 

Technologies
 

CodeDigest Navigation
 

Technology News
No News Feeds available at this time.
 

Community News
No News Feeds available at this time.
 
Report Caching

By Selva kumar
Posted On Mar 17,2008
Article Rating:
Be first to rate
this article.
No of Comments: 2
Category: Reporting Services
Print this article.

Report Caching

Report Caching is used to improve performance

There are 2 types of caching:

Temporary Cached Report:

·          Copy of report in intermediate format stored in the ReportServerTempDB Database.

·          Copy is rendered in the desired format when report is requested.

·          It is cached on first use.

·          Cached copy expires by a predetermined method.

Snapshot Report:

 Is a form of cached report. These reports are built and stored in the Report Server Database in the intermediate format on a predefined schedule and not upon user request.

 

Report can not be set up to be cached IF:

·          Credentials are not stored

·          Data Source credentials can not be set to prompt or integrated

·          Report Parameter is set to Prompt User

Report will not pull from the cache IF:

·          Report Parameter Changes

·          Report Definition Changes

·          Data Source Credentials Change

·          Cache Options change



Changing report layout or data source does not affect the saved snapshots

By default, cached reports are saved in ReportServerTempDB

It can be stored in the filesystem, too (saves server round-trips. Only useful for Remote catalogs.)

·          This can be configured in RSReportServer.config file

·          WebServiceUseFileShareStorage

<Add Key="WebServiceUseFileShareStorage" Value="true" />

·          WindowsServiceUseFileShareStorage

<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>

·          FileShareStorageLocation

<FileShareStorageLocation><Path></Path></FileShareStorageLocation>

Default Location : C:\Program Files\Microsoft SQL Server\MSSQL\MSSQL.instance\Reporting Services\RSTempFiles

Similar Articles

You can contribute to CodeDiget.Com:
Donate to CodeDigest.com
Article Feedback
Comments
1bRYk3 , [url=http://xxexiqwrqcxv.com/]xxexiqwrqcxv[/url], [link=http://ygziapumzist.com/]ygziapumzist[/link], http://bmeeyaklsens.com/
1bRYk3 , [url=http://xxexiqwrqcxv.com/]xxexiqwrqcxv[/url], [link=http://ygziapumzist.com/]ygziapumzist[/link], http://bmeeyaklsens.com/
This posting konkecd my socks off
This posting konkecd my socks off