开发者

Is there significant overhead for PRINT statements in SQL Server 2005 Stored Procedures?

I noticed in a code review that one developer added PRINT statements throughout many SQL Server stored procedures.

These stored procedures are executed from a ASP.NET website, using 开发者_运维技巧SqlClient.

Is there any performance penalty to having these PRINT statement in the code? Or will they automatically be skipped when the procs are called from Sql Client via ASP.NET?

I'm running Sql Server 2005.


As noted here, "when using the SqlClient provider...messages do not alter control flow and can be intercepted by application code by registering a callback for the InfoMessage event handler."

Do they cause significant overheard? Probably not. Would I allow them to remain in the procedure when they serve no purpose for the application? NO.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜