Re: Sqlldr versus inserts

On 03/12/2007 07:52:43 AM, John Dunn wrote:
> We currently load large amounts of data into a table using sqlldr which
> is run from a unix script initiated from a java stored procedure.
> The application designers want to eliminate the script and load the data
> directly using java and jdbc, which I presume will mean using insert
> statements.
>  
> Sound like a bad idea to me from a performance point of view, but am I
> correct? If not using sqllldr what oprions are there to read a flat file
> and inseet the data. Will external files give the same performance as
> sqlldr?
>  

First, you should have added Perl to the mix. If you have Java and shell script 
in
the mix, there is no reason not to have a Perl script in there, too. 
Second, JDBC can handle array inserts and direct inserts. There is absolutely 
no reason to call either a shell script or a SQL*Loader. Third, yeah, loader 
will 
be faster then sqlplus, for most of the cases. Now, how about having Java code 
call
shell script which calls Perl interpreter? Sounds optimal to me.

-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l

Other related posts: