Post reply

Does Commenting Degardes performance of SQL Server

  • April 24, 2006 at 3:47 am

    #169060

    Hi All,

    I have a doubt whether the presence of commented lines in a Stored Procedures will affect the Performance of execution.

     

    Assume that In a Stored procedure with 1500 lines, 1300 lines of code are commented, can anyone let me know whether the presence of this comment will degarde the execution or by any means will it affect the performance of Sql server

     

    Thanks and Regards

    Raghu

     

  • April 24, 2006 at 6:07 am

    #633744

     

    No effect on execution time. No effect on compilation time either but I suppose you should have some effect on parse time. It is also consuming some additional amounts of memory, but the total effect is so small I would be surprised if you were able to mesure it (other variables have much more effect).

    If it was ad hoc sql, going through the network, that would be different. I have seen --censored-- programmers comment out large chunks of TSQL and execute it thousands of times in a loop (with no prepare). That has a mesurable effect

     

    L

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply