>When developping an app, performance is key to me and my colleagues, so I
Amongst other things (from the "ADO.NET Best Practices" document by
"Best Practices with SqlCommand
A quick tip for executing stored procedures using the SqlCommand: If
you are calling a stored procedure, specify a CommandType of
StoredProcedure for the CommandType property of the SqlCommand. This
removes the need to parse the command before execution, by explicitly
identifying it as a stored procedure."
Also, as mentioned by SQL Server architect Gert Drapers at TechEd
2004, using the "Execute <sproc name>" way of doing things is a so
called "Text Event", which is inherently less efficient than when
using the CommandType = StoredProc, in which case the stored proc is
called using a RPC (remote procedure call) event.
I can't quantify in terms of milliseconds or % CPU Load, but since
both a best practices document describes it, and SQL Server architects
recommend it, I guess there's a good reason why you should do it that
Marc Scheuner May The Source Be With You!
Berne, Switzerland m.scheuner -at- inova.ch