better to have something other than CF do this really....Hammer in hand, everything looks like a nail, eh? If using Oracle, could use SQL Loader.
DK On 7/26/06, Martin Thorpe <[EMAIL PROTECTED]> 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:247746 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
