Re: Java stored procedures. Are they slower than PL/SQL?

From: John Darrah <john.darrah_at_spambadusa.net>
Date: 4 Oct 2001 18:04:23 GMT
Message-ID: <1002218219.796736@proxy.storm.co.za>

I ran some tests with java stored procs and pl/sql and found java to be about 10X slower regarding data retrevial than pl/sql. there is some good data supporting this at
http://www.interealm.com/technotes/larry/languages.html

Don Chambers wrote:

> 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

Posted via www.orafocus.com - Focusing on the World of Oracle Received on Thu Oct 04 2001 - 13:04:23 CDT