开发者

Stored procedure Vs SSRS table

开发者 https://www.devze.com 2023-02-15 22:14 出处:网络
I\'m getting different experience here I\'ve a stored procedure and while I\'m trying to execute procedure in query window of SQL Server 2008 it is taking around 5 to 6 mins for me to execute (Becaus

I'm getting different experience here

I've a stored procedure and while I'm trying to execute procedure in query window of SQL Server 2008 it is taking around 5 to 6 mins for me to execute (Because it is having multiple subqueries)

But the same p开发者_C百科rocedure I've executed through SSRS table. I'm getting results in SSRS table with in less than a minute.

How it is possible? Did SSRS handling this time internally? or any other reason?

Thank you

0

精彩评论

暂无评论...
验证码 换一张
取 消