Re: Benchmarks - Java vs PL/SQL

From: <jdarrah_co_at_my-deja.com>
Date: Wed, 13 Dec 2000 21:58:01 GMT
Message-ID: <918rd5$bve$1@nnrp1.deja.com>

A friend of mine did just such a benchmark. I don't have a public site. but if anyone does, I'd be happy to post the results and code. The short of it is java and pl/sql perform equally well when SQL is not involved but when the code issued a "select 'X' from dual", pl/sql outperformed java by as much as 50X. this was tested on NT 816 linux 816 and solaris 817 and pl/sql easily outperformed java stored procs in all of these environments. That being said, I would love for someone with more experience using java stored procs to look at this test.

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 Wed Dec 13 2000 - 15:58:01 CST