Post reply

XML Vs Non-XML

  • January 19, 2021 at 12:10 pm

    #3834966

    I am using SQL Server 2008 R2.

    While using XML data type and  XQuery slow (50 Times slow) compare to Non-xml Method(Relational Database Model) even after adding XML Index.

    So is it ok if we move from XML to Non-XML option?

     

  • January 19, 2021 at 12:21 pm

    #3834967

    In all seriousness, how do you expect us to be able to say whether this is OK or not without no knowledge about your system or what the impact would be?

    Yes, I much prefer to store data from XML documents in relational format than as an XML document, but I have absolute no knowledge of what may break.

     

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • January 20, 2021 at 4:38 am

    #3835335

    If  Execution speed is the only issue, can we move ?

  • January 20, 2021 at 4:26 pm

    #3835564

    IT researcher wrote:

    If  Execution speed is the only issue, can we move ?

    There's only one way to know for sure... stand up an instance on your dev box and test it.

    I do strongly agree with Erland.  If it were up to me, I wouldn't allow XML to be stored in SQL Server.  There could be exceptions to that but generally, IMHO, not.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 3 (of 3 total)

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