How widespread is the use of triggers these days and how concerned about performance?....

From: Nari Kannan <nkannan_at_earthlink.net>
Date: 1 Aug 2003 18:53:50 -0700
Message-ID: <59a2b424.0308011753.5fd08e1e_at_posting.google.com>

Fifteen years ago when databases were primarily used in the context of transaction-intensive applications, triggers were a nice feature of a DBMS system that did not get used because of performance concerns.

Fast forward 15 years, it seems to me that 95% of database usage is for
non-transaction intensive information (I could be wrong in this). Given this I see increasing usage of triggers for doing various necessary things that regular reporting does not do.

Am I just dreaming or that triggers are being increasingly used?

Are performance concerns not important in the above context as long as you
are mindful of stuff like cascading triggers and keeping the trigger code short?

Thanks in advance for your insights, experiences and opinions.

Nari Kannan Received on Sat Aug 02 2003 - 03:53:50 CEST

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message