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

From: Don Chambers <dchamber_at_mindspring.com>
Date: 3 Oct 2001 20:44:02 -0500
Message-ID: <4bfnrt4k1kgkv1rhp452v62n4ermejtjur_at_4ax.com>

[Quoted] [Quoted] 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 - 03:44:02 CEST