Reporting Services initial page load takes to long.

I have looked all over to get an answer to the following:
I have installed Reporting Services with the latest service pack. When
I or any of my customers try to initially load the default page
(http://localhost/reports/Pages/Folder.aspx) it will take 20-30
seconds. After the initial load it is fine. The next day when we try
to access it again, it takes 20-30 seconds again. I have seen two
people ask the same question on the newsgroups with no answers.
Some may feel this is not a big deal, but I am moving from one
reporting service to "Reporting Services" and the less issues my
customers have the easier it will be for me to sell this. If I could
get this corrected it would be great, but if I can not, I would at
least like a logical reason why this occurs.
Also
Is there an equivalent function in RS to Crystal's "Next" command
I am converting a report from Crystal to Reporting Services and I need
the ability to look ahead by one row (the Next command in Crystal) and
use this data from the result set to perform certain calculation. If
there is not a similar command is there a way to do this short of
creating a temp table and using a cursor?
Thanks,
TomThe initial delay occurs when ASP.Net first compiles all of the assemblies.
This occurs during the first access only. After a period of time of
inactivity the ASP.Net worker process is unloaded and the whole thing must
start over again.
For you second question I would start a new thread with a subject which
reflects the question, otherwise it might not get answered.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom" <tom_barnard@.aotx.uscourts.gov> wrote in message
news:1096037678.531999.323430@.k26g2000oda.googlegroups.com...
> I have looked all over to get an answer to the following:
> I have installed Reporting Services with the latest service pack. When
> I or any of my customers try to initially load the default page
> (http://localhost/reports/Pages/Folder.aspx) it will take 20-30
> seconds. After the initial load it is fine. The next day when we try
> to access it again, it takes 20-30 seconds again. I have seen two
> people ask the same question on the newsgroups with no answers.
> Some may feel this is not a big deal, but I am moving from one
> reporting service to "Reporting Services" and the less issues my
> customers have the easier it will be for me to sell this. If I could
> get this corrected it would be great, but if I can not, I would at
> least like a logical reason why this occurs.
> Also
> Is there an equivalent function in RS to Crystal's "Next" command
> I am converting a report from Crystal to Reporting Services and I need
> the ability to look ahead by one row (the Next command in Crystal) and
> use this data from the result set to perform certain calculation. If
> there is not a similar command is there a way to do this short of
> creating a temp table and using a cursor?
>
> Thanks,
> Tom
>