D
Debasish Pramanik
We do a FOR XML query using SQLXMLReader.ExecuteXMLReader() method. The
results is obtained in a XMLReader. We then load XMlDocument using XmlReader
as we have to process the XML.
When we try to fire a query which returns huge data, the query executed by
database is 6 seconds but to load the XML it takes 30 minutes. It could be
30-50 MB xml.
Is there any better way to load the XML.
results is obtained in a XMLReader. We then load XMlDocument using XmlReader
as we have to process the XML.
When we try to fire a query which returns huge data, the query executed by
database is 6 seconds but to load the XML it takes 30 minutes. It could be
30-50 MB xml.
Is there any better way to load the XML.