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

[Quoted] Hello Sammy,

I'm afraid it will be hard to beat a lump of well-written C, you could of course try Assembler.

Sybrand says that with PL/SQL you could avoid network traffic, but I don't see why the C-program couldn't run on the server as well.

But why do you intend to rewrite it?

Gerard

sammy_6_at_my-deja.com wrote:
>
> 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 Fri Aug 11 2000 - 00:00:00 CEST