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

If you run the C program on the server the program will still need to fetch the data, so this will *still* mean a network protocol (in this case IPC) is used to transport the data from the dedicated server process to the client program.

Regards,

Sybrand Bakker, Oracle DBA

"Gerard H. Pille" <ghp_at_skynet.be> wrote in message news:39939416.DB60E99C_at_skynet.be...
> 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