Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Benchmarks - Java vs PL/SQL
This post is right on the money.
In article <3A3BB8DC.9E14E0E0_at_hotmail.com>,
rickhall2000_at_hotmail.com wrote:
> I did some looking into this because I was considering rewriting some
PL/SQL
> sp's in Java. According to Oracle, for sp's that are processing
intensive,
> Java can out perform PL/SQL 5 to 1. For sp's that are data intensive
PL/SQL
> will out perform Java at 10:1.
>
> I wish I had a link to this, but search on Oracle's site, the info is
there.
>
> Rick
>
> Ezr Vinh wrote:
>
> > I'd love to see some accurate test results on this subject also. I
> > would tend to believe the PL/SQL is faster, but I don't have any
hard
> > data to confirm this belief.
> >
> > Performance aside, I prefer writing in PL/SQL over Java for the
sake of
> > simplicity, efficiency, and maintainability. PL/SQL is, after all,
the
> > native language of the database. IMO, Oracle only added Java
because it
> > is currently fashionable.
> >
> > In article <3A371221.2B95B228_at_intersystemsww.com>,
> > Avi Abrami <aabrami_at_intersystemsww.com> wrote:
> > > I am looking for some performance
> > > measurements/comparisons for stored
> > > procedures in PL/SQL versus stored
> > > procedures in Java.
> > >
> > > We are trying to decide whether it is
> > > better to write our stored procedures
> > > in Java or PL/SQL.
> > >
> > > TIA,
> > > Avi.
> > >
> > >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>
Sent via Deja.com
http://www.deja.com/
Received on Wed Jan 10 2001 - 18:03:37 CST