Re: How widespread is the use of triggers these days and how concerned about performance?....
From: Fred Prose <fprose_at_hotmail.com>
Date: 4 Aug 2003 07:41:44 -0700
Message-ID: <195a4770.0308040641.5e3682c5_at_posting.google.com>
Date: 4 Aug 2003 07:41:44 -0700
Message-ID: <195a4770.0308040641.5e3682c5_at_posting.google.com>
The average DBA can not enforce programming standards or review code - time and policy usually will not allow it. And today's databases are updated from a multitude of sources outside the immediate control of the server and the DBA. I have seen production databases destroyed by end users and an Excel spreadsheet because by policy update rights were not removed. And what DBA hasn't taken the rap for poor application performance?
Where mainframe based OLTP platforms managed problems such as deadlocks and rollbacks, the client-server DBMS systems of today leave much of those issues to the programmer to design, program, and react to. And let me ask - have you ever met a programmer who really understood concurrency?