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:247979 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
