Post reply

XML Performance Issues

  • May 24, 2010 at 6:35 am

    #221442

    I'm having issues with a non-performant SP that shreds a good amount of data in xml. I switched from just using xquery to OPENXML and that seemed to help a bit. I'm just wanting a little bit better performance. The XML variable is being passed into other SP's and functions to do processing (inserts and such), so within each of those SP's and functions, the xml has to be shredded or the sp_xml_preparedocument has to be called so it can load the xml data into cache. Can anybody think of any alternatives, maybe have something that persists through the sp execution that I could take advantage of?

    Best,

    Yoshimi

  • May 24, 2010 at 7:04 am

    #1171528

    Would you mind sharing a sample portion of your XML file together with your target table structure and your original XQuery code? I'm pretty sure the final solution will outperform the OPENROWSET approach... 😉


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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