Re: Hello, a question comparing sql server to Oracle

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. ***