Caching reports
Not all reports are required to be shown with real-time data, hence if the report can be internally saved with initial execution and can be used as a pre-loaded report for next request, it will surely shorten the time for satisfying user's request as it does not need to spend time on processing the report along with data extraction. This can be achieved by caching the report.
Getting ready
For improving the overall performance there are some important settings that you need to understand if you want to cache the report. Remember, if you enable caching, you need to make sure either it get's expired based on a pre-defined time-frame or it is linked with a Cache Refresh Plan. Otherwise, the report will deliver with the cached copy even ...
Get SQL Server 2016 Reporting Services Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
