Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Java in Stored Procs

Java in Stored Procs

From: Don Seiler <don_at_seiler.us>
Date: Tue, 3 Jul 2007 16:56:27 -0500
Message-ID: <716f7a630707031456y79f37a03t77e0af32453d478e@mail.gmail.com>


Today one of my developers asked about having java code in our DB (10.2.0.2). He had already been playing around with it some, and found it much slower. Not really a scientific test, but he found that calling java routines from the PowerBuilder front-end could handle 1 million records in 52s, where as calling the same routine from within his stored proc was much slower (10k records in 24s). He's now looking at native compilation [1] as a way to speed things up.

We are "a java shop" and the main goal here is re-use of existing data processing code, so that we don't have to update the same logic in multiple places.

I thought I remembered reading a paper or presentation that mentioned some solid reasons for keeping java out of the database. Feuerstein or Kyte perhaps.

I'd like to know what you fine folks have to say about the matter. Should never the twain meet? Anyone with ncomp experience?

[1] http://download.oracle.com/docs/cd/B19306_01/java.102/b14187/chten.htm#sthref505

-- 
Don Seiler
oracle blog: http://ora.seiler.us
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 03 2007 - 16:56:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US