Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 necessarilyReceived on Wed Jan 24 2001 - 06:37:26 CST
![]() |
![]() |