Yes... I was going to mention that but I didn't want to muddy the waters :)
Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Ian Skinner [mailto:[email protected]] Sent: Tuesday, May 26, 2009 11:10 AM To: cf-talk Subject: Re: Parsing large CSVs and inserting in MSSQL Mark Kruger wrote: > Jason, > > But if you insist on doing it with CF, don't use CFFILE. Instead read > the lines in one at a time using a line reader technique - that will > allow you to handle one line at a time instead of reding the entire file into memory. I also recommended pushing the heavy lifting into the database. But I did want to point out that in ColdFusion 8, you can now use the <cfloop file=""....> tag to get a CFML line reader, so one does not need to go to the Java for this anymore. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322786 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
