SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Java stored procedure vs. PL-SQL vs. external java program

703698Jun 15 2009 — edited Jun 15 2009

Hi,

I'm using a stored procedure for running a query and a few consequent updates. Currently I'm using Java stored procedure for that, which was my choice for simplicity on one hand, and running with the DB on the other.

In my tests, strangely enough it came out that running as java stored procedure was 3-4 times slower than running as a java program outside the database. I don't know how to explain this, and I wonder if switching to PL/SQL will improve the performance of the code.

Any experiences? recommendations?

Thanks,
Dawg

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2009

Added on Jun 15 2009

3 comments

481 views