>- see footer for list info -< My initial thought was to do a bulk insert in sql or changing the timeout setting in cf.
----- Original Message ----- From: Lee Fortnam <[email protected]> To: [email protected] Sent: Wed, 13 Oct 2010 19:43:59 -0400 (EDT) Subject: [CF-Dev] Entering large CSV file into DB regularly >- see footer for list info -< Hi All, I know this might be off topic for a CF discussion group but as CF is the language I would be potentially handling this in I'll give it a shot. I have a service which regularly (once every 24 hours) needs to retrieve a number of files from an FTP site. The issue is the file is 12MB in size as a zipped CSV file. When unzipped the file is some 78MB in size. I need to import all of this CSV file into an existing table, all fields will be imported etc. Is there a GOOD efficient way to do this without killing the DB server or having CF time out. This is on a dedicated instance of CF on a semi dedicated box at CFMX hosting. I have no native access to the MS SQL 2005 DB file system. Thanks in advance. Lee Fortnam _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
