can you use cfsetting and increase the timeout massively for that request to stop the timeout?
If you are reading in a huge file, cffile is not good, as it can will read in the entire file to memory (I understand this has been imporved in CF8) The is an example of using Java to read in a file line in CF7 here: "[path to cfide]/cfide/gettingstarted/experience/index_content.cfm" then "Code Snippets by Feature and Tasks" Under "Java Integration" so, with those two, could you read in the file and put it in your DB? Rob Wilson wrote: > Hi Grant, > we have used > http://www.emerle.net/programming/display.cfm/t/cfx_text2query with success > > Cheers > Rob > > > _____ > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of grant > Sent: Thursday, 14 June 2007 9:54 AM > To: cfaussie@googlegroups.com > Subject: [cfaussie] Large CSV's and server timeouts > > > Hi y'All > > Here's the scenario: we have a csv file that contains 1.5 million rows and > is provided by an external vendor. we need to either (a) parse the csv and > insert into a DB, or (b) do lookups directly on the csv. > > We do not and cannot have SQLloader. The DB is ORA10g. The servers are old > and under fairly high load all the time. > > We've tried splitting the csv into smaller chunks and inserting into the DB > and also trying a SQL link straight into the CSV. Anything we try time's out > and basically brings down the server. > > Who can shed light on the most efficient way to solve this problem? > Thanks > Grant --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
