Re: Java stored procedure performance dilemma

It might be useful to have an example of a typical but small Java procedure, and an example of how it is being called.

Any of the various bits of advice to date may be suitable depending on actual current use. Some of them may turn out to be very bad advice simply because they're not relevant to your situation.

The basic issue you need to address is whether you problem is in:

    database calls to java
    java calls to the database
    the java
    the particular use of stored procedures     the strategic infrastructure

A concrete example might help us w.r.t the first four.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9   (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Colin McGuire wrote in message ...


>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