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: Finn Ellebaek Nielsen <_remove_fen_remove__at_changegroup.dk>
Date: Fri, 18 Oct 2002 12:08:02 +0200
Message-ID: <3dafdd7c$0$28814$edfadb0f@dspool01.news.tele.dk>


Hi Colin.

A few suggestions:

HTH. Finn

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:aooem1$as3$1$8302bc10_at_news.demon.co.uk...
>
> 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
>
>
Received on Fri Oct 18 2002 - 05:08:02 CDT

Original text of this message

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