Report caching

Hi all,
I have a report that takes about 10 minutes to run for a given date. How can
I cache it some how so that it would run lot faster for the same data input
(date) later on?
Thanks in advance.You can have the report run from the cache... ON the reporting Server,
select the report-Properties... You can set the report to run from cache and
choose the cache refresh schedule... The first person who runs the report
after the cache has expired, must wait... Others during the period get fast
response.
If you do not want to wait the first time, you may run a snapshot for the
report on a schedule and have the report rendered from the snapshot...
However The only reports which will be rendered must be snapshotted with the
appropriate report parameters...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Trisha" <trisha@.nospam.nospam> wrote in message
news:CB6AB88B-40D6-4E26-A40C-9F086B171142@.microsoft.com...
> Hi all,
> I have a report that takes about 10 minutes to run for a given date. How
> can
> I cache it some how so that it would run lot faster for the same data
> input
> (date) later on?
> Thanks in advance.|||Wayne,
What if I want to cache the report for several different input parameters.
What if I have several different reports w/several different parameters.
Would all those reports be cached on the server for each of the executed
input parameters? If thats the case, then it would put lots of load on the
server and I might have to look into a different strategy.
Thanks again..
"Wayne Snyder" wrote:
> You can have the report run from the cache... ON the reporting Server,
> select the report-Properties... You can set the report to run from cache and
> choose the cache refresh schedule... The first person who runs the report
> after the cache has expired, must wait... Others during the period get fast
> response.
> If you do not want to wait the first time, you may run a snapshot for the
> report on a schedule and have the report rendered from the snapshot...
> However The only reports which will be rendered must be snapshotted with the
> appropriate report parameters...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:CB6AB88B-40D6-4E26-A40C-9F086B171142@.microsoft.com...
> > Hi all,
> >
> > I have a report that takes about 10 minutes to run for a given date. How
> > can
> > I cache it some how so that it would run lot faster for the same data
> > input
> > (date) later on?
> >
> > Thanks in advance.
>
>