You are not logged in.

#1 2005-04-28 21:52:56

Arch Overlord
From: behind you
Registered: 2003-10-29
Posts: 7,879

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:

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

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?


Board footer

Powered by FluxBB