Triggers are not a performance drain, in and of themselves. If they are well written, and well managed, they can be perfectly acceptable ways of performing important tasks.
The problem lies in that often times, they are NOT well written and NOT well managed. They can be pretty easily overused and abused.....at which point they can become a performance drain. > Just in case my thinking has been wrong for the last few years, how are > triggers a performance drain??? If I can make one query to a database > and then have the db handle some of the other operations I need to run, > that sounds like a pretty efficient way to handle it to me. > > --Ferg > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: Monday, April 18, 2005 7:54 AM > To: CF-Talk > Subject: RE: SQL Triggers (was Re: Last ID inserted) > > Well, for one they can be hard to track / find if you are not the > developer > and have sufficient rights to look at them, they are also a performance > drain when simple constraint should be enough. > > Most cases which use a trigger now are unnecessary. > > > > > > -----Original Message----- > From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] > Sent: 18 April 2005 13:27 > To: CF-Talk > Subject: SQL Triggers (was Re: Last ID inserted) > >> Triggers...?! ;-) evil evil evil... > > Why do you say that? > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203234 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
