Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Java stored procedures. Are they slower than PL/SQL?

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@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 Wed Oct 03 2001 - 20:44:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US