Re: Can my loader run as fast as SQL*Loader?

SQL*Loader uses bind arrays for an array insert, have you tried to achieve the same thing with you're loader. Also in Oracle 8/8i there is a new kind of Insert called a direct load insert, have a look in the oracle technet for more details.

It's unlikely that your own loader will ever be as as fast as SQL*Loader, but if you need extra flexibility thats the way to go.

gaop_at_my-deja.com wrote in message <7soa2r$kab$1_at_nnrp1.deja.com>...
>
>
>I loaded some data using Oracle SQL*Loader, using Conventional Path,
>since a column of my data is of object type.
>I also loaded the same data using JDBC with a prepared INSERT
>statement.
>
>The SQL*Loader loaded the data in about 20 secs, but my loader
>loaded the same data in 30 Minutes!
>
>As I understanded, SQL*Loader Conventional Path goes through the
>same path as a user program. Anyway I can tune my loader to go
>as fast as SQL*Loader?
>
>Thanks for any help.
>
>Gao Peng
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Sep 28 1999 - 04:52:13 CDT