On 4/22/05, sandeep dubey <dubey.sandeep_at_gmail.com> 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
Received on Fri Apr 22 2005 - 13:52:57 CDT
