|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Loading Large XMLWe 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. Hiya,
When you say it took 6 seconds for the query to complete, are you sure it's actually completed? Even though the reader starts returning data, i'm fairly sure this does not mean all the data for the query has been full prepared. If i'm not talking garbage, it could mean that your query is actually taking 30 minutes to fully complete, in which case, optimizing your query may be better then changing the way you load your xml Andrew Show quote "Debasish Pramanik" <Debasish Prama***@discussions.microsoft.com> wrote in message news:994F1554-46DF-47C5-AE32-839334B002F2@microsoft.com... > 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.  
Other interesting topics
|
|||||||||||||||||||||||
