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: Hello, a question comparing sql server to Oracle

Re: Hello, a question comparing sql server to Oracle

From: HansF <News.Hans_at_telus.net>
Date: Mon, 01 May 2006 17:14:38 GMT
Message-Id: <pan.2006.05.01.17.14.38.519365@telus.net>


On Mon, 01 May 2006 09:56:25 -0700, Mark wrote:

> But there is so much written in the
> newsgroup about pl/sql being slow so I don't want to code the trigger in
> pl/sql if there is a more efficient way of doing it.
>

When doing things the wrong way - yes, PL/SQL could be slow.

Using PL/SQL when a simple set operation would have done the trick is invariably doing to be slower than the set operation.

That's like saying "I have a dump truck, but I need to put the load into the cab because all I know is how to handle a car. So each trip leaves the dumpster empty, and I need a lot of trips. A lot slower than doing it right."

But ... PL/SQL is slow - that's yet another myth.

(In fact, PL/SQL can be compiled to native C ... which is reasonably fast. But still slower than doing it right.)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***
Received on Mon May 01 2006 - 12:14:38 CDT

Original text of this message

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