[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