Arch Linux

phrakture

Arch Overlord

From: behind you

Registered: 2003-10-29

Posts: 7,879

Website

really OT: SQL Server openxml performance

ok, for any of you who are SQL Server pros:

I've noticed a recent degrade in the performance of the openxml() function - not much has changed except the names of root nodes and things like that...

but a simple xml doc looking like this:

<roles>
   <user_role job="1" approver="123" />
   <user_role job="4" approver="735" />
   <user_role job="9" approver="883" />
</roles>

takes 3 seconds to spit into a table variable... 3 seconds!  the explain plan list it as taking 95% of the stored proc performance.... sigh

is there anything that can be done?

---

http://phraktured.net