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 procedure performance dilemma

Re: Java stored procedure performance dilemma

From: dmz17 <dmz17_at_nospam.nowhere.com>
Date: Fri, 18 Oct 2002 17:37:31 +0200
Message-ID: <pan.2002.10.18.15.37.31.240583@nospam.nowhere.com>


On Thu, 17 Oct 2002 20:34:50 +0000, Brian Peasland wrote:

>> I agree. Then again, I never learned PL/SQL ;-)

>
> Maybe you should!!! Its pretty easy to pick up.
>
> The general rule of thumb goes as follows:
>
> 1. If it can be done with straight SQL, then use straight SQL.
> 2. If #1 is not possible, use PL/SQL.
> 3. If #2 is not possible, then use Java.
> 4. If #3 is not possible, then use C.
>
> Of course, we are talking about accessing data and running stored
> procedure in the database, not in your application here. If I was doing
> something really complex, mathematically, such as working with Fast
> Fourier Transforms, then I wouldn't even be doing that in the database!
> I'd code it straight in my application and run it on an nice high-end
> workstation!!! ;)
>
> Cheers,
> Brian

Yeah, maybe. Alas, Life is short and Java just about keeps me busy as H... ;-)

Cheers,

dmz17 Received on Fri Oct 18 2002 - 10:37:31 CDT

Original text of this message

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