Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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. ***Received on Mon May 01 2006 - 12:14:38 CDT
![]() |
![]() |