O'Reilly logo

SQL Server 2016 Reporting Services Cookbook by Robert C. Cain, Dinesh Priyankara

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required