Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Benchmarks - Java vs PL/SQL
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/
Received on Sat Dec 16 2000 - 12:47:56 CST