performance of report on ssrs

jamesmetcalf74 used Ask the Experts™
query performance question.  I have a query that uses multiple databases(the databases are all on the same instance of sql).  The query takes about a minute to complete.  This is acceptable, but when ssrs runs off this dataset, it is painfully slow.   4 to 5 minutes to render.  

1) is it normal for there to be a drop off in the speed of ssrs displaying the results as compared to the actual speed of the query in ssms.  I suspect there should be but, is 4 to 5 times something that i should be wary of?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
How big (number of rows and row size) is the record set returned by the query? Alternatively you could try make it SP instead of SSRS query.
Also, does it takes that long to render executed ON the SSRS Server or on a client via the browser.


We redesigned the query...  it runs better now

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial