Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Java stored procedure performance dilemma

Re: Java stored procedure performance dilemma

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 16 Oct 2002 21:05:16 +0100
Message-ID: <3DADC67C.413F@yahoo.com>


Colin McGuire wrote:
>
> I am involved with small team of programmers that have just finished
> writing a suite of Java routines that perform some grunt-job string
> manipulation/processing :- the algorithms implemented as Java stored
> procedures. Unfortunately, at this late stage in the play, performance
> has become an issue and we realise we have probably made an incorrect
> technical decision early on. Our reasons for initially choosing Java
> as the development environment were the familiar ones but platform
> independence should not have been one of the reasons as our code is
> intimately tied to Oracle. During a recent technical meeting it was
> mentioned one solution might be to rewrite (ie translate) our library
> routines from Java to Pro/C++, the latter I believe shipped with all
> flavours of Oracle and thus would run on every machine Oracle ran on,
> compile to fast native code etc. We have decided on having a think
> about this approach, weigh up the pro's and con's, and discuss again
> from an informed perspective at the next meeting.
>
> I would be interested in opinions from interested parties in the
> forum, other alternatives to our dilemma etc.
> Thank you
> Colin

I'm no java-on-oracle expert, but I understood that there was a native compiler for java to allow C-like speed...

Others may correct me..

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Wed Oct 16 2002 - 15:05:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US