Re: Performance: java called from a Java Stored Proc versus direct call
PLSQL is the fastest code that could run on oracle database engine.
Even though Oracle puts it as a built-in JVM that runs java stored procedures, JVM is running basically in a secluded memory space in the SGA. Also there are issues of JVM's method of running the byte code.. It is not JIT mode.
I feel that you cannot bring the difference to less than 4 times, whatsoever optimized java code you would write ...
Yeah... so there is really a big overhead when using Oracle's internal JVM?
But, now that I'm thinking... it mustn't really be 6 times (or 4 times like u said) slower, but only some overhead on each call of the method... so it would be more precise to say, that when I call through PL/SQL it takes 6 seconds cuz there's a 5 second overhead which doesn't occur when the call is made directly to the JVM. Meaning, if a call should last 10min, in PL it would last 10min + 5 secs, and not 60min. Right?