XML Parser Performance

  • I have an extremely long running query, actually 25 of them, that I inherited. They all access XML documents stored in table columns with XML datatypes.

    Their execution plans show that almost 100% of their time is spent on XML Parser objects. Is there anything I can do to speed up XML Parsing or is it "black box" so to speak.

    Thanks a lot,

    dn

  • Have you looked at adding XML indexes to the columns?

    I've found that parsing out XML is a major performance hog, but with XML indexes it becomes fast and painless.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

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