Re: embedded java

To further refine that answer, I was told that pl/sql would be the better choice if doing strictly database things, e.g. select, insert, update... but java would be better for doing mathematical manipulations, e.g. floating point division.

hope that helps,
cindy

Goin'n bold wrote:

> Hmmmm,
>
> the Oracle people that did a presentation regarding Java support for me
> on the Oracle database said PL/SQL is going to be the fastest of the
> two.
>
> I guess the recomendation here should be to use PL/SQL when speed is
> required. Java is good in doing alot of things but PL/SQL is optimized
> for working in the Oracle database and will normaly be the faster of
> the two when in that environment.
>
> Only advice for now is to rewrite the time critical parts in PL/SQL.
> And only run Java when your not in need of speed....
>
> /JEr
>
> In article <8hQY3.468$as2.2010_at_news.iol.ie>,
> ericm_at_iol.ie (Eric Mosley) wrote:
> > I'm finding that when we switched some embedded functions from pl/sql
> to
> > java we experienced a massive performance reduction...
> > Any body else with similar findings?
> >
> > -Eric
> >
> > ------------------------------------------------------------
> > Eric Mosley we're doing this free for YOU!
> > eric_at_globogift.com
> > http://www.globogift.com
> > ------------------------------------------------------------
> >
>
> --
> Gandhi: An eye for an eye only ends up making the whole world blind.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 18 1999 - 13:43:33 CST