Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Cache Refresh Options
There are limitations to each of the two processing options just discussed: caching and report snapshots. Caching does not create a cached copy of a report until the report is actually executed by a user. If a report has a number of parameters, then a cached copy of the report suitable to satisfy requests for a given combination of parameters is not created until a user first executes the report with that combination of parameters.
Report snapshots allow for a “preexecuted” version of a report to be created in advance, but that preexecuted version can only be created for the default parameters assigned to that report. Given these limitations, it is clear we need a more flexible form of caching. Fortunately, Reporting Services has cache refresh options to fill this need.

  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint