May 18, 2005 at 2:55 pm
I'm using SQLXMLBULKLOAD class, If the source XML file is big(bigger then 10 MB), it takes couple of hours. ...
Does anyone have any tips for improving the performance of
SQLXMLBulkLoad ?
Thanks in advance!
May 19, 2005 at 9:02 am
you'd need to include more detail on the schema you are importing. i routinely import very large xml files (100-200mb) and they only take a few minutes. i get in hr-xml a lot which has a fairly deep schema and i normally just write a stylesheet to transform it via xmldom to a more flat schema then run the importer. imported almost 1gb yesterday in maybe an hour (including transformation time) larger files will suck up a ton of memory while to do the transform if you use xmldom but something that small should take seconds to transform and seconds to import.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply