Hi @.all,
I designed a query in report designer, data tab. This query runs 24 secs, when I execute it from the data tab in report designer.
Publishing the report and running it from the report server. The query needs 40x the time as in report designer.
Looking at the Execution Log, the report needs 800 secs for TimeDataRetrieval.
Why is it so much slower to run the query from report server? The report designer has also to retrieve the data, and runs so much faster.
Thanks for any hints
T
The data tab will only retrieve data, so the report design may be the cause for bad performance. How much time does it take to preview the report in your report designer?
Shyam
|||I'll try that,
but isn't this time which gets reported in ExecutionLog in Cols TimeProcessing and TimeRendering?
