Re: Java stored procedure performance dilemma

From: dmz17 <dmz17_at_nospam.nowhere.com>
Date: Thu, 17 Oct 2002 07:12:39 +0200
Message-ID: <pan.2002.10.17.05.12.38.981313@nospam.nowhere.com>

On Wed, 16 Oct 2002 20:28:34 +0000, Brian Peasland wrote:

> Have you looked at writing your procs in PL/SQL? You may find that
> PL/SQL can't do everything that you need it to do. But if it does, then
> this should run faster than Java or C in the database.
>

In principle, I believe the current thinking is that for complex math Java outperforms PL/SQL by a factor of 40-50.

For massive data manipulation PL/SQL outperforms Java by a factor of 40-50.

As always, your mileage may vary hugely.

Has the OP considered a search in the existing code for performance hogs, like too many context switches and such?

There is no doubt that C++ is faster than Java, but there is a native compiler option for the database that also would assure platform independence.

Cheers,

dmz17 Received on Thu Oct 17 2002 - 00:12:39 CDT