> anything you can do to stop workload on CF is great, therefore i think > triggers would be a great option for this that aside here are some of > the costs involved: > > Performance impact - Triggers have to write to one or more local > tables that act as audit trails. With moderate or heavy transaction > volume the performance degradation increases. > > Consolidation of the audit trail - A trigger instruments one database > server and writes an audit trail on the local machines. But > monitoring multiple servers and consolidating the audit trail in a > central repository is difficult to do correctly with triggers. > > Incomplete coverage - A trigger can only capture data changes - > UPDATE, INSERT, DELETE. Triggers cannot capture changes to schema and > object permissions. > > Maintenance burden - Like any other program, once triggers are > correctly written, they must be maintained. Triggers are tightly > coupled to the structure of a table, so each time the table schema > changes, the trigger code must be rewritten. > > Complexity - Adding more triggers to address auditing requirements > increases complexity of the environment, leading to a higher > probability of bugs and incorrect logic. > > HTH > REF: http://wapurl.co.uk/?743R18A > On 25/05/06, Ken Ferguson <[EMAIL PROTECTED]> wrote: > > We have CFCs which handle all of our crud operations on form data. What > > we do for auditing is to call the corresponding function from the > > auditing component before making any updates or deletes. This > > essentially inserts all of the data from the rows that a user is about > > to update/delete prior to the operation. These audit tables also have > > columns dedicated to tracking the user information... It seems to work > > pretty well. Be careful though, as this can be a very resource-intensive > > task if you're auditing changes for a lot of data in a high-traffic > > environment. -- Nick Tong
web: http://talkwebsolutions.co.uk blog: http://succor.co.uk shorturls: http://wapurl.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241517 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
