Triggers : Performance Trade Off?

From: Jcen <hang_at_programmer.net>
Date: 1997/09/12
Message-ID: <34194a33.15741206@news.singnet.com.sg>#1/1

Hi,

I have a database on hand to manage ever since I took over the responsibility of looking after this baby. I discover that no trigger was programmed into the database. Anything that seems great and beneficial to have triggers are coded in Stored Procedures instead.
I am wondering, was the avoidance of triggers due to a performance issue?
Would having triggers slow down a database? Would it be faster to have the code in a stored procedure than in a separate trigger procedures?

Any opinions and comments are welcomed.
Thanks.

jcen Received on Fri Sep 12 1997 - 00:00:00 CDT