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?