Here's a question which has been bugging me for ages!! And the best help I know is on this list so if you guys don't know I'm in the next batch of Tesco value dogfood!!
I am currently using cffile and cfhttp to extract the contents of csv files and then import to a sql database. The questions I have is: 1. The current method is fine with few lines in the csv file but when dealing with large amounts of data it slows down considerably. Is there another way to get the information into the database quicker i.e coldfusion dsn 2. when using a coldfusion dsn to import contents of files into a db would I have to create a dsn to the file or could I have a dsn to the directory 3. How do I go about creating a dsn to a file/directory? Cheers in advance Chris -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
