Home » SQL & PL/SQL » SQL & PL/SQL » The Trouble with Triggers.
The Trouble with Triggers. [message #346476] Mon, 08 September 2008 12:29 Go to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
http://rwijk.blogspot.com/2007/09/database-triggers-are-evil.html

Let the religious discussions begin.
Re: The Trouble with Triggers. [message #346478 is a reply to message #346476] Mon, 08 September 2008 12:35 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
Wasn't that a Star Trek Original Series episode?
Re: The Trouble with Triggers. [message #346491 is a reply to message #346478] Mon, 08 September 2008 13:15 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:
Wasn't that a Star Trek Original Series episode?


That was about Tribbles, small annoying things that get on everyone's nerves when there are more than a few,
whereas Triggers are.... are.... uhhhhhhh.... I think you are right after all.
Re: The Trouble with Triggers. [message #346609 is a reply to message #346491] Tue, 09 September 2008 02:22 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Tribbles breed faster than triggers (generally), but are also cuter.

Triggers are just a tool, albeit one that many people seem to use wrongly.
Re: The Trouble with Triggers. [message #346615 is a reply to message #346609] Tue, 09 September 2008 02:38 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
JRowbottom wrote on Tue, 09 September 2008 09:22
Triggers are just a tool, albeit one that many people seem to use wrongly.

Very well put.
Claiming that triggers are evil as a generalisation is like saying that rm is evil, since it can accidentally remove more files than you intended, when used wrongly.
Re: The Trouble with Triggers. [message #346699 is a reply to message #346615] Tue, 09 September 2008 07:54 Go to previous message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
Tom also had a great article on this in the latest oracle mag I think.
Previous Topic: Question on Exchange partition
Next Topic: Problem with Calling Procedure (PL/SQL)
Goto Forum:
  


Current Time: Wed Dec 07 20:45:56 CST 2016

Total time taken to generate the page: 0.06339 seconds