Java stored procedure performance

From: rob burton <robburton_at_totalise.co.uk>
Date: 27 Nov 2001 07:59:55 -0800
Message-ID: <feb77408.0111270759.5278c8e2@posting.google.com>

I have a java stored procedure compiled on 8.1.6 running on Solaris that is loaded as a SQLJ file. The stored procedure calls a cryptography package to perform numerically intensive public key encryption/decryption. (The cryptography package itself is loaded as a jar file.)

The java code performs very poorly when run by the Oracle JVM

Typically a procedure call taking 1/3 second running on an external JVM, takes about 30 seconds within Oracle.

Does any one know why there is such a difference in performance between the two.

Thanks

Rob.. Received on Tue Nov 27 2001 - 09:59:55 CST