开发者

Stored procedure Vs SSRS table

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜