Grant,
That's why I thought I would add that there might be an application already out there, I can't be 100% sure but I have seen apps that have been able to manipulate CSV files (IIS Server log files in particular) but whether they will do what you are looking at doing then that I can't answer. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of grant Sent: Thursday, 14 June 2007 10:11 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Large CSV's and server timeouts Thanks Andrew. That's actually the path we're heading down (a custom java app); I thought I'd post here to ensure we're not re-inventing the wheel... Thanks! On 14/06/07, Scott Thornton <[EMAIL PROTECTED]> wrote: Perhaps you could import it into MS Access (by hand) then into Oracle. I am a MS SQL user myself so I do not know what oracle tools there are available. >>> grant < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > 14/06/2007 9:53 am >>> 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 <br --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
