Martin Thorpe wrote: > > 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.
You're probably just finding the inserts are going really slowly if there are a hundreds of thousands of rows. what youre doing would probably be better off using a DTS package (SQL Server 2000), or whatever they call it in SQL Server 2005... sql*loader in Oracle, etc. If the java code that I posted didn't make things faster, it's almost certainly the database activity that's going slowly. If you really want to do this with CF, you could try some asynchronous operations using the recently posted CFTHREAD/CFJOIN functionality (I don't remember the link directly but I blogged it on opensourcecf.com) You could get 50 threads running at the same time doing database inserts.. not sure if that would help either though. rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:247753 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
