Re: PL/SQL performance question

Marcel Stör wrote:

> Hi all,
>
> Just out of curiosity, I'd like to get your opinion on the following
> scenario:
> Lots of data (i.e. 2 million records) are periodically loaded into the db
> through SQL Loader. Unfortunately, each record needs to be tweaked before
> will eventually be saved. Would it be faster to have an on-insert trigger do
> this at record level or to have a procedure that will run once all records
> are stored in the table?
>
> Regards,
> Marcel
>

Does the tweaking depend on other data already in the database?

If not, you might find it *much* faster to process the data before loading it. Perl is very good at manipulating flat files and runs everywhere Oracle does (and lots of places it doesn't), and it should be easy to find or develop your own expertise.

If you only need some look-up information from the database to do the tweaking, Perl can handle that too.

--Mark Bole Received on Wed May 12 2004 - 19:14:10 CDT