SQL Server Performance

Using XML as parameter

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by wkm1925, Mar 2, 2010.

  1. wkm1925 New Member

    Let's say, my xml data as follow,
    <data>
    <cout><short>kl</short></cout>
    <cout><short>jb</short></cout>
    <cout><short>sg</short></cout>
    </data>
    I intent to using this xml data as my parameter to perform insert/update
    Is that using xml data as parameter will hurt the performance?
    wkm1925, Mar 2, 2010
    #2

  2. FrankKalis Moderator

    That depends on a number of factors, such as how often you use this, how large the xml data is. how busy the table is, etc...
    We use this quite frequently for passing say 10 - 20 items in the xml to the proc and do some merge logic and are quite happy with it. Performance was not our main objective but rather providing a fixed and reliable interface that can be called once for multi-row operations from various clients and the client developers are happy because they can use their soo much beloved XML to communicate with the database. [:)]
    FrankKalis, Mar 3, 2010
    #3

Share This Page