PiMané (1/16/2013)
GSquared (1/16/2013)
Personally, I use XQuery (nodes, et al) consistently. Haven't used OpenXML in years. Prefer XQuery for performance, ease-of-use, etc.I use it also but in this example OPENXML is 4x faster getting the data...
It's probably cause the XML has lots of columns in the output.. If I just use 10 columns the nodes is faster.
In the example sent, with just 10 columns on the output, nodes is 2.5x faster...
Thanks,
Pedro
The usual rule applies then. Use whatever works better. These things are very situationally dependent, so OpenXML may very well be your best bet in this case.
- 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