November 1, 2011 at 1:14 am
Hi,
I've around 50 input parameters to be passed from the UI to my stored procedure.
I'd like to know which would be best from performance and maintenance point of view - concatenating the values and passing it as a single xml parameter or passing each parameters separately...
Suggestions are welcome.
Thanks,
Ganesh
November 1, 2011 at 4:00 am
This was removed by the editor as SPAM
November 11, 2011 at 11:26 am
Ganesh,
This depends on how you would rather handle it in the stored procedure vs the front end. If there's a very good reason for the front end to handle the parameters as a single XML string, then that would be the way to go.
I normally, however, don't use XML to pass in a bunch of parameters from a front end as one parameter. It's not as easy to debug on the SQL Server side. Much easier to have the individual parameters passed in.
Todd Fifield
November 11, 2011 at 11:41 am
Thanks for the replies.
We've decided against using XML parameter mainly to avoid additional overhead to the application in buidling the XML tags and decoding them in the backend for every record that gets processed.
Also couldnt find any big performance-boosting factor in passing XML tag as the parameter.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply