November 15, 2007 at 10:32 am
Hi all,
I am investigating improving report performance by implementing caching. Our reports are based on a datawarehouse which is refreshed daily. My plan was to create a data-driven subscription (DDS) for each report, using the NULL DELIVERY PROVIDER in order to create the 'cached' versions early each morning, then using a shared schedule ("Expire the reports") to expire all the cached versions late at night. Each DDS would be linked to a shared schedule ("Create Cached Versions").
The problem is, that if I set a report to "Cache a temporary copy of the report. Expire copy of report after a number of minutes" then the caching works great. If I set it to "Cache a temporary copy of the report. Expire copy of report on the following schedule" and select my shared schedule, then the caching doesn't work. That is, reports ALWAYS re-run the query and re-render - they don't read from a cached version.
Has anyone encountered this?
Thanks,
Matt.
November 16, 2007 at 2:52 am
Hi again,
I have found that if I set the shared expiration schedule to run, say daily at 1am - or anything but ONCE - then it is fine. Not really sure why it doesn't work if the schedule is set to run once, but now I know at least I can work around it.
Regards,
Matt.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply