Can my loader run as fast as SQL*Loader?

From: <gaop_at_my-deja.com>
Date: Mon, 27 Sep 1999 17:38:37 GMT
Message-ID: <7soa2r$kab$1@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 Mon Sep 27 1999 - 12:38:37 CDT