Query Performance

Hi,
I have a query which takes approx 45 sec to execute in Query Analyzer but it
takes more than 60 min to execute in MSRS. What is the reason for it and how
to improve it's performance ?
ThanksHi push:
Could you show us the query?
--
Scott
http://www.OdeToCode.com
On Fri, 20 Aug 2004 02:37:01 -0700, "push"
<push@.discussions.microsoft.com> wrote:
>Hi,
>I have a query which takes approx 45 sec to execute in Query Analyzer but it
>takes more than 60 min to execute in MSRS. What is the reason for it and how
>to improve it's performance ?
>Thanks|||push wrote:
> I have a query which takes approx 45 sec to execute in Query Analyzer but it
> takes more than 60 min to execute in MSRS. What is the reason for it and how
> to improve it's performance ?
I would first try and pinpoint where the time is being taken. Looking
at the ExecutionLog in the Report Server catalog database would tell you
the total row count and how the total report rendering time divides up
between data retrieval, internal processing, and format-specific
rendering. Could you post these numbers as well as a brief description
of the hardware you're running this on? An example query would be nice
as well.
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.