ReportManager is faster than ReportServer-why?

I have a report based on a stored procedure. The procedure runs very fast
from Query Analyzer. The Report I build from it runs a little slower
in "Preview", I assume due to the Grouping I am doing. It takes about 1 sec.
Then when I move it to production and view it through ReportManager is it
slower,
maybe 3 sec. I wish I knew why.
But when I run it via URL from Reportserver, like this:
http://serveripname/Reportserver?/InstructorReports/AdminListAll"
it runs a couple of seconds slower yet.
Does anyone know why the rendor time isn't the same in all 3 cases?
thanks,
VinceUsing instructions on
http://msdn.microsoft.com/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp,
you should be able to pull down ExecutionLog details for analysis. This
will let you look at each report exeuciton to see if there really is any
difference in data retrieval, processing and render times. After you use DTS
to pull down the RS Execution Log details, run SELECT * FROM
[RSExecutionLog].[dbo].[ExecutionLogs] within Query Analyzer to look for
differences.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"thomsonDeveloper" <thomsonDeveloper@.discussions.microsoft.com> wrote in
message news:434FE938-0D45-4527-923E-8E007C930F5C@.microsoft.com...
>I have a report based on a stored procedure. The procedure runs very fast
> from Query Analyzer. The Report I build from it runs a little slower
> in "Preview", I assume due to the Grouping I am doing. It takes about 1
> sec.
> Then when I move it to production and view it through ReportManager is it
> slower,
> maybe 3 sec. I wish I knew why.
> But when I run it via URL from Reportserver, like this:
> http://serveripname/Reportserver?/InstructorReports/AdminListAll"
> it runs a couple of seconds slower yet.
> Does anyone know why the rendor time isn't the same in all 3 cases?
> thanks,
> Vince
>