Print

Hi all,
Can anyone tell me if by having a print of a variable i.e. (print @.strsql)
in a stored procedure slows down the overall performace, even by millisecond
s
as I have run some test with STATISTICS TIME ON and most of the time they ar
e
quicker with the print in, is this right?
Thanks PhilAny time you send more data, it's going to slow down a little bit. Whether
it is measurable really depends on your hardware and other factors, so
you're just going to have to test it.
For more interesting results, test a stored procedure that returns multiple
resultsets, and then put SET NOCOUNT ON at the beginning and test it again.
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:4EBF1ED7-775C-490D-A074-AC1D1EB247AB@.microsoft.com...
> Hi all,
> Can anyone tell me if by having a print of a variable i.e. (print @.strsql)
> in a stored procedure slows down the overall performace, even by
> milliseconds
> as I have run some test with STATISTICS TIME ON and most of the time they
> are
> quicker with the print in, is this right?
> Thanks Phil