SV: PL/SQL vs Java Stored Procedure

Hi

It depends, it's absolutely not a statement which holds for all the code that exists.
Code closely related to the database is - off course - faster executed in the database.

What you might be thinking about is, that Oracle precompiles the Java code, so that it is faster when executed in the database compared to when executed in a normal runtime environment.

But there are a lot of features etc. in Java which might be slow when done in PL/SQL.

Also you have to take into account when to convert from Oracle datatypes to Java and back. It's costly.....

When the pl/sql procedure is slow, you may get improved performance in Java, but this - off course - depends.....

The main benefit - as I see it - is that you now can write object oriented code in the database.

Does anybody have some experience?

;-)
Kim

-----Oprindelig meddelelse-----
Fra: Arul kumar [mailto:rakumar_at_mahindrabt.com] Sendt: 24. januar 2001 12:11
Til: Multiple recipients of list ORACLE-L Emne: Re: PL/SQL vs Java Stored Procedure

Hi,

Good Idea!.

Somewhere I read (some benchmark test!) that in 8i (latest release - not sure abt. the ver.!) , it
is many times faster in executing the same code written in Java rather than pl/sql.

Worth giving a try!.

Arul.

Andor Gyula wrote:

> Hi Gurus !
>
> We created a stored procedure perfoms huge amount of string operations. It
was created in PL/SQL
> it's very slow. Does it worth trying to implement it in Java stored
procedure? Any experience?
>
> Thanks in adance
> Gyula
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Andor Gyula
> INET: gy.andor_at_euromacc.hu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arul kumar
  INET: rakumar_at_mahindrabt.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



The information in this e-mail and any attached files is confidential.  It
is intended solely for the use of the addressee.  Any unauthorised
disclosure or  use is prohibited.  If you are not the intended recipient of
the message, please notify the sender immediately and do not disclose the
contents to any other person, use it for any purpose, or store or copy the
information in any medium.  The views of the author may not necessarily