Are Triggers Really that Bad or ....???

From: Ronnie Yours <ronnie_yours_at_yahoo.com>
Date: Wed, 24 Jul 2002 14:47:30 -0400
Message-ID: <ahmsm4$gd5$1@nntp-m01.news.aol.com>

Hi,

I am facing a wierd situation here.

We have a database with around 150-200 Tables and growing . Each Table has 4 columns in additional to the ones for the application, namely created_by, created_date,updated_by and updated_date. Now when writing the application code the developers were supposed to take care of the values in these fields. For example when a record is added/inserted the created_by and created_date fields are populated and when the records are updated the updated_by and updated_dates are populated/updated.
But the issue is the developeres did not take care of this issue and one of the senior developers is suggesting that lets create triggers to implement this functionality.

My suggestion was and is that lets change the code to take care of this but he doesnt agree. He says it will take more time to do that.

Now I am in a dilemma.

If we implement triggers how will they affect the prformance. If I should not implement triggers then how should I go about handling this situation and explain the same to my manager.

Please Suggest

Thanks
Ronnie Yours Received on Wed Jul 24 2002 - 13:47:30 CDT