[thelist] Cold Fusion + Large Query

Adrian Gonzales adrian at clearspanmedia.com
Wed Mar 31 08:08:35 CST 2004


I'm trying to get an XML file with 20K entries into SQL.  I can't get
CFMX to get over about 2000 before giving up.  This script:

Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
objBL.ConnectionString = "provider=SQLOLEDB.1;data
source=mysource;database=mydb;uid=sa;pwd=mypass"
objBL.ErrorLogFile = "c:\web\error.log"
objBL.Execute "c:\web\datamapping.xml", "c:\web\XMLData.xml"
Set objBL = Nothing
 
That loads it in about 10 seconds.  REALLY FAST.
 
Is there a way to get CFMX to load it fast into SQL?
 
Adrian Gonzales Jr.
Creative Director
Clear Span Media
clearspanmedia.com <http://www.clearspanmedia.com/> 
 


More information about the thelist mailing list