I've used Perl to prepare large files for SQL Loader.
1.9 million. SQL loader is fast, I was able to load the 1.9 mill records in
less than six minutes.
We had to do text extraction for the data.
DBI is absolutley awesome for that IMHO.
clp
-----Original Message-----
From: Curt Russell Crandall [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 11:24 AM
To: Marcotullio, Angelo
Cc: '[EMAIL PROTECTED]'
Subject: Re: Data Extract
For a half a billion rows, I would seriously consider coding this in C
using whatever Oracle libraries are available for accessing
the API. That
would probably be your best choice in terms of having speedy
code. You
may also be able to do a large portion of your work in a
stored procedure
as well.
Perl is awesome and the DBI is great... but for 500,000,000
rows of data
it may not be the best alternative depending on your speed
requirements.
--Curt
