I have posted SQLXMLBulkLoad4Class question in XML and the .NET Framework
forum. No one answered. Try my luck here.
According to http://msdn.microsoft.com/en-us/library/ms171721.aspx -- "You can insert XML data into a SQL Server database by using an INSERT statement and the OPENXML function; however, the Bulk Load utility provides better performance when you need
to insert large amounts of XML data." I thought "SQLXML Bulkload 4.0 Type Library" was a component to use for fast importing large xml file.
I have created 10 tables with auto increase primary keys and foreign keys in SQL Server database and used the following codes to shred a 390 MB file into those tables without any transformation. It took me around an hour. What a disappointment!
Flatting this file into an in-memory table and importing it with SqlBulkCopy or using SSIS only took me around 6 minutes.
Did anyone experience this? Is SQLXMLBulkLoad4Class simply just so slow or is it misused by me?
SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class objBL = new SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class();
View Complete Post