Re: Updategram Out of Memory! Do I need BulkLoad? How do I delete?

Updategrams are meant for smaller resyncs since it uses the DOM internally
you get a size explosion of a factor of 5 (average) in memory...

If you just want to load the data (no deletion) you should really go and use
the SQLXML Bulkload since it is streaming the data...

Best regards
Michael

"Cynric" <Cynric.29p6u4@xxxxxxxxxxxx> wrote in message
news:Cynric.29p6u4@xxxxxxxxxxxxxxx

Hi

I have had the same problem.

I have managed it, with no longer use updategram, and make instead a
temp- table where I make lonly inserts from XML with an XSL. After
inserting all, my stored- procedure looks if all data has come and it
transferrs all data in the right table, with transaction- handling.

With updategram i have seen memory-usage upto 200 MB size, for
transferring an XML of 5MB !! That was too much for my systems.

You can use updategrams only upto 500KB-XML-Files.:(



--
Cynric
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message560839.html



.

Relevant Pages

  • Re: synchronize SQL-server with XML document once a day
    ... There are basically 2 standard approaches for updating data using XML; ... SQL Server (which you can do through ADO, managed SqlXml classes, or HTTP ... To insert data, well - you can use UpdateGrams, Diffgrams again, or the ...
    (microsoft.public.sqlserver.xml)
  • Re: How to update XML data stored in SQL Server?
    ... Updategrams may be a better fit than diffgrams since it supports identity ... For unbound types, which I assume that it is the same concept as open ... insert records from the input Xml. ... > I am currently designing the relational database tables to represent the ...
    (microsoft.public.sqlserver.xml)
  • Re: XML Import options
    ... OpenXML may work as well, but if the documents are too big, you get into ... > XML was ... > and have looked at openXML, XMLBulkLoad/DTS and Updategrams. ... > data (i.e. in XML files on the filesystem) I would have to activate the ...
    (microsoft.public.sqlserver.xml)
  • Re: Sending XML From .Net To SQLServer
    ... Look at SqlXml and UpdateGrams. ... > Nowadays I'm using the Update Method from DataAdapter but i figure out ... > it generate multiples roundtrip to my dbserver so i want to use XML to ... > I saw that in SQLServer exist OPENXML function to accomplish that but i ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Sending XML From .Net To SQLServer
    ... Look at SqlXml and UpdateGrams. ... >> it generate multiples roundtrip to my dbserver so i want to use XML to ... >> I saw that in SQLServer exist OPENXML function to accomplish that but i ...
    (microsoft.public.dotnet.framework.adonet)
Loading