Sorry to come in late in the convo... If you can put the file in a public directory, I have found from some simple testing that CFHttp is faster than a buffered file reader...
http://bennadel.com/blog/200-ColdFusion-CFHttp-To-Query-Much-Faster-Than-Jav a-Buffered-Reader.htm DISCLAIMER: I am a ColdFusion programmer, not a Java programmer, so there are probably issues. ....................... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Chris Tilley [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 3:26 PM To: CF-Talk Subject: Re: Bulk data loading I've tried it but getting an error message: 12:52:15.015 - Expression Exception - in D:\Inetpub\cf\WorkingCapitalFund\FileReader.cfc : line 65 Variable RETURNSTRING is undefined. Any ideas why? On 9/6/06, Rick Root <[EMAIL PROTECTED]> wrote: > > Rick Root wrote: > > I blogged the method at www.opensourcecf.com =) > > specifically... > > > http://www.opensourcecf.com/1/2006/07/Reading-large-files-with-java-ve > rsus-CFFILE.cfm > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252267 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4