• 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?


  • 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]

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

  • 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".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

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

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

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