Java and JavaScript in the Database

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!

Performance of Java stored procedures (too slow)

430128Dec 8 2006 — edited Dec 25 2006

Hello,

I have uploaded Java classes to Oracle. But they are executed about 10 times slower than on my PC (as a stand alone module testing with JUnit, not inside Oracle) - 40 sec instead of 4 sec.

My Java classes queries some tables about 3 times (seems it's not a lock) and then calculating 3 matrixes (about 8x8). That calculation seems is indeed the place where it spends a time because it takes about 60 millisecond and it's repeated about 150x5 times.

So, are there any ways to increase the performance? Is it normal that on my PC it works much faster than being uploaded to Oracle? Maybe something wrong with OracleJVM instalation or settings?

Thanks in advance.
Nikolay

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 22 2007

Added on Dec 8 2006

5 comments

2,544 views