Re: brutally simple question - number of triggers on a table
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: dubey.sandeep@xxxxxxxxx
- Date: Fri, 22 Apr 2005 18:47:24 +0100
On 4/22/05, sandeep dubey <dubey.sandeep@xxxxxxxxx> wrote:
>
> The place where I work, doesn't have a single trigger. The application
> architect is of strong opinion that when business logic is stored in
> the database in form of triggers when 1000+ transactions hitting the
> same table at sime time, database cannot perform. Here we have rigid
> SLA requirements. All business logic is stored in middleware in
> application which in turn clustered and load balanced. Any backdoor
> data updates (from SQL) passes through strong QA audit.
Does he have evidence for his opinion? Not a dig, just a question.
Personally I'd be loathe to allow even QA'd changes via efficient methods if
all integrity rules exist elsewhere - qa isn't as strong as RI. But then as
we just run best of breed software with no constraints what would I know.
--
> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
