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 - 04:18:51 CDT
