Performance question

[Jake]

Hello,

I was wondering if there was a big performance enhancement using
commantype.storedprocedure opposed to commandtype.text in a webservice, or
what other benefits there would be with respect to scalability etc.. We are
using sql2k standard and planning on getting sql2k5 when it's released.
Thanks.

Jake

 

[Ken Dopierala Jr.]

Hi Jake,

You will definitely notice a performance increase using SPs. Also it will
help protect you from SQL Injection vulnerabilities. Finally, with VS.Net,
you can right click on your SP, run it with arguements, and even set
breakpoints. This is way cooler than trying to concatenate some long SQL
Query and playing around with the Query Analyzer to see if you got it right.
Good luck! Ken.