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 -> Java stored procedure performance dilemma

Java stored procedure performance dilemma

From: Colin McGuire <colinandkaren_at_lycos.co.uk>
Date: 16 Oct 2002 12:56:53 -0700
Message-ID: <ab6cea37.0210161156.423d90ba@posting.google.com>


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 Received on Wed Oct 16 2002 - 14:56:53 CDT

Original text of this message

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