Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Java stored procedures. Are they slower than PL/SQL?
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
![]() |
![]() |