PL/SQL, JAVA, PRO*C Performance which is best ?

From: <sammy_6_at_my-deja.com>
Date: 2000/08/10
Message-ID: <8mu10r$baq$1_at_nnrp1.deja.com>#1/1


[Quoted] [Quoted] We have an old lump of PRO*C which does loan calculations. We are moving to oracle 8 and intend to rewrite the code. It is important that it is fast. Does any body know of the performance differences between the languages. The database access of the code is minimal and is not really important.
I get a feeling that loanding the 'arrays' into pl/sql index tables instead of the pro*c arrays we will get comparable performance. I presume the nature of Oracle JAVA will mean its not good for this application.
Anybody have any clues ? I dont want to spend 2 Months rewriting the code in either PL/SQL or JAVA to find out they are too slow and end up reverting to calling the original 'C' program.

Yours Optimistically,

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 10 2000 - 00:00:00 CEST

Original text of this message