Re: brutally simple question - number of triggers on a table

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

--
http://www.freelists.org/webpage/oracle-l

Other related posts: