Re: PL/SQL vs Java Stored Procedure

From: Roby Sherman <rxsherm_at_interealm.com>
Date: Wed, 24 Jan 2001 07:05:32 -0700
Message-Id: <10751.127355@fatcity.com>

Arul kumar wrote:

Oracle's JVM is generally much slower than PL/SQL for string handling (unless you NCOMP the class.) If performance is a concern, you may want to try C or run the class in an external JVM with a JIT.

For more info, refer to the article:

http://www.interealm.com/orageeks/technotes/larry/languages.html

--Roby

> 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).
Received on Wed Jan 24 2001 - 08:05:32 CST