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


Other related posts: