Re: Triggers/sequences or interface code

From: Pablo Sanchez <pablo_at_dev.null>
Date: Sat, 27 Apr 2002 22:31:22 -0600
Message-ID: <xWKy8.88$fb7.142616@news.uswest.net>

"J. Harris" <harris.john.a_at_worldnet.att.net> wrote in message news:BpIy8.54380$QC1.3962966_at_bgtnsc04-news.ops.worldnet.att.net...
> I really appreciate your good answers.
>
> Is it fair to say, then, that we have a choice of application
performance
> vs. code maintenance/reusability/portability? I guess most of us
would go
> for application performance, but in light of this thread should code
> maintenance be considered? Any advice?

With 'proper' abstraction, you may elect to have all your inserts run go through a layer of PL/SQL sproc's that higher levels invoke. This way you end up with the best of both worlds:

performance and maintainability -- Pablo Sanchez, High-Performance Database Engineering mailto:pablo_at_hpdbe.com Available for short-term and long-term contracts

Received on Sat Apr 27 2002 - 23:31:22 CDT