Re: Benchmarks - Java vs PL/SQL

From: <sgpal_at_hotmail.com>
Date: Wed, 10 Jan 2001 23:18:24 GMT
Message-ID: <93iqjn$nvf$1@nnrp1.deja.com>

Looks like I came late to the party. My experience with Java SP's has been that PL/SQL is 2 times faster than JDBC and 3 times faster than SQLJ for a typical stored procedure I wrote - select with a few joins and wrapping through the cursor.

This performance was for Oracle 8i Rel 2 (8.1.6). There are several performance upgrades in the works like JAccelerator and improved SQLJ to JDBC operations in Oracle 8i Release 3. If the performance impact is fairly negligible then on most projects, Java would be the preferred option, simply because it reduces the need for another programming language skill, and I get binary as well as logical portability of my database code.

My 2 cents,

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 Jan 10 2001 - 17:18:24 CST