BizTalk Utilities CV ,   Jobs ,   Code library
Go to the front page to continue learning about XML or select below:


ReBlogger Contents

Previous posts in XML

Page 7439 of 21350

FOR XML Performance with SQL 2005

Blogger :
All posts : All posts by
Category : XML
Blogged date : 2008 Jan 08

We had a requirement to generate some extract data in the form of XML.
So while designing the solution, I had 2 options.
1. Use FOR XML in the Query with SQL 2005
2. Use regular SQL Queries and usign a Custom DataSet, serialize the data to XML.

SQL 2005 has nice options to get the XML.
You can assign name spaces to nodes, can have nested XMLs, can have custom Root and Child Xml node names.
One example can be found here.

But FOR XML queries are much slower when getting huge amounts of data.
You can find a comparison here.,289483,sid87_gci1265579,00.html

So the bottom line is, FORXML is suitable only for small output.
Else do the logic in the business components.
And in most of the circumstances, the load on the database need to be kept low.
Hence second method was found the more suitable one.

Read comments or post a reply to : FOR XML Performance with SQL 2005
Page 7439 of 21350

Newest posts

    Email TopXML