Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: bulk load of data
Why is SQL*Loader too slow?
What are the time constraints, seconds, minutes, hours?
SQL*Loader can process millions of records, but much depends on what must be done on the data in terms of transformations and integrity and on the hardware resources available.
Bye,
Flavio
"John Leslie" <johnleslie_at_madasafish.com> wrote in message
news:4412dd31.0303010245.1b2bd4c2_at_posting.google.com...
> Age old question I guess, but looking for the up to date answer.
>
>
> We have requirement to process up to 500,000 records of data currently
> held in a text file.
>
> Currently we process these through external C procedures and only
> totals are loaded into the database, Now we have a functional
> requirement which probably means we need to load all the records into
> a database table.
>
> Is sqlloader still the quickest option?
>
> What other options are there? We know that utl_file is too slow.
> External tables?
>
> Platform is 8.1.7 on AIX moving soon to 9i release 2
>
> If there any up to date documents or discussion threads you can point
> me at please do so.
>
> John
Received on Sat Mar 01 2003 - 07:34:59 CST