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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203224 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
