Home » Developer & Programmer » JDeveloper, Java & XML » Java Stored Procedures take longer to execute
Java Stored Procedures take longer to execute [message #196982] Mon, 09 October 2006 08:02
nusratz
Messages: 1
Registered: October 2006
Junior Member
Hi,
I am doing a comparison of Oracle and Java Stored procedures in terms of execution time. I have created a java stored procedure and an Oracle stored procedure both of which perform the same task. Upon execution, I find that the java procedure takes longer time to execute.
I have the following qs:-
Why is a Java Stored Procedure slower than an Oracle Stored Procedure?
How is a java stored procedure executed as compared to an Oracle Stored Procedure?
Can someone give a detailed explanation of -
- how a java stored procedure is stored in the database?
- what happens when it is executed?

Thanks in advance
Nusrat
Previous Topic: PL/SQL calling Java
Next Topic: PreparedStatement In Table Partition - Select * From Table Partition (?)
Goto Forum:
  


Current Time: Thu Mar 28 11:31:15 CDT 2024