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

Home -> Community -> Usenet -> c.d.o.server -> Re: java stored procedures fast, but slow when called as SQL function

Re: java stored procedures fast, but slow when called as SQL function

From: <ctcgag_at_hotmail.com>
Date: 10 Apr 2003 15:26:36 GMT
Message-ID: <20030410112636.791$Oh@newsreader.com>


Noons <wizofoz2k_at_yahoo.com.au.nospam> wrote:
> Following up on , 09 Apr 2003:
>
> >
> > If I call one Java SP that does a lot of (non SQL) work and write the
> > equivalent in PL/SQL, the Java version is up to 10 times faster. For
> > example a prime number calculation.
>
> OK. Now, instead of using floating point arithmetic, try
> something more mundane like heavy string manipulations.

I hope you don't implement prime number calculations using floating point numbers!

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB
Received on Thu Apr 10 2003 - 10:26:36 CDT

Original text of this message

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