sql server reporting services: Daily Caching -- sql server reporting services

Re: Daily Caching

Daniel Reib [MSFT]
12/29/2004 10:29:10 AM

sql server reporting services: It depends on the execution settings of the report. If the report is set to
cache the execution and the DD subscription runs with all parameter
combinations, and the cache expiration is sufficiently long enough then
users will get cached renderings, they will not get any recent data.

Using a snapshot is another possibility, the only problem is that any
parameters that affect the query will be locked and users will not be able
to change them.

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Daily Caching

John Geddes
12/29/2004 1:56:04 PM

I have set up a data-drive subscription to do a null report on a report
that takes 3 minutes to run.

I have it set up to run at 3 am and it works fine.

My question is when a user runs it at 6 am, does it use what I cached
plus the new data, or does it re-cache the whole thing?
This report is intense and I really do not want to run it during the day
if I don't have to.

If it constantly re-caches the report, would creating a snapshot on a
schedule be the better option?

Thanks.