Re: Java stored procedures. Are they slower than PL/SQL?
Date: Thu, 4 Oct 2001 11:18:51 +0200
Message-ID: <9ph9i2$r41$1_at_rex.ip-plus.net>
The difference between Java and PL/SQL is that Java has to go through JDBC to access data tables, while PL/SQL goes straight to the SQL engine. I asked some people at Oracle about which language is best where, and the answer is that Java is better for computing-intensive procedures with few data accesses, while PL/SQL is better for procedures with heavy data access.
HTH
"Don Chambers" <dchamber_at_mindspring.com> wrote in message
news:4bfnrt4k1kgkv1rhp452v62n4ermejtjur_at_4ax.com...
> I have created my first java stored procedure and it seems very slow.
> I use it to move a large amount from a load table to main tables. In
> a previous design we used PL/SQL procs and this load took about 8
> hours. Based on the number of rows that loaded before I left tonight
> it looks like the JAVA proc will take over 20 hours. Why the HUGE
> difference?
>
> Is there a way to speed this up?
> Are the java procs compiled or do they use the just in time compiler?
>
> Thanks,
> Don
Received on Thu Oct 04 2001 - 11:18:51 CEST