So, he goes out installs and uses a different CFML engine just to read a text file line by line when he can code the same thing in ColdFusion (not using CFFILE)?
Seems a little silly. "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: gert franz <[EMAIL PROTECTED]> To: CF-Talk <cf-talk@houseoffusion.com> Sent: Fri Jul 28 08:48:40 2006 Subject: Re: reading large text file Hi Martin, you could use Railo instead, since Railo can loop through a large file line by line without reading it completely. Just use the <cfloop file="..."> tag to process the file, just as explained here: http://www.railo.ch/en/index.cfm?treeID=144 Regards Gert Greetings / GrĂ¼sse Gert Franz Customer Care [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ Martin Thorpe wrote: > Hello all. > > > > I am uploading a 74 + MB tab delimited text file that I am then reading > and inserting the values into a database. The problem is it always > times out, or just takes too long (did not finish over night!!!!) to > read the file. It is uploaded fine. > > Any suggestions about how I may approach this to make it work with such > large files? > > I looked at a bit of Java code someone had posted here but it went no > quicker really. > > I was thinking of maybe chopping the file into slices and then > processing but not too sure how I would approach this. > > > > Any opinions or ideas/tips would be gratefully accepted. > > > > Thanks for reading. > > Cheers > > Martin > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:247980 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4