Post reply

String Manipulation

  • August 13, 2010 at 5:17 am

    #97250

    Hi All,

    I have a question ,Is parsing xml leads to performance hit?

    If yes ,please provide with reasons and overcoming it

  • August 13, 2010 at 6:16 am

    #1206550

    ningaraju.n (8/13/2010)

    Hi All,

    I have a question ,Is parsing xml leads to performance hit?

    i like to think of xml as a table or table variable. since xml is not indexed the way a table in SQL server would(could) be, it's more intensive to parse xml; it's like a table scan for each xml field. indexes and statistics on a regualr table are how SQL server can do shortcuts to get the data based on the sampling of the data and the indexes keeping track of data in an ordered manner; each time there's no way i know of to do that to xml (yet?)

    If yes ,please provide with reasons and overcoming it

    "it depends" is the answer here; it may be that nothing can be done; for exmaple if you are using xml to import data from an external source; nothing wrong with that.

    if you are having a noticable performance issue using xml somewhere, give some more details, and we might offer some suggestions.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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