XML Parsing drawbacks

  • Hi all,

    I am desperately looking for any studies/articles/whitepapers done on the XML parsing performance on SQL Server 2005 as compared to parsing on the applicatiion level (in a .NET C# application for instance).

    Does anyone have any hints or links on this?

    thanks a lot

  • Just an observation, but I believe most XQuery commands need string literals for their parameters, not strings (so no variables). So if you know the schema structure and are querying against that, you're okay, but if you're writing code to explore, it gets harder. You're stuck using dynamic SQL, and to my knowledge, there's no ChildNodes equivalent. If someone knows otherwise, I'm very interested.

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

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