Understanding triggers

- Understanding triggers in sequel…Triggers are blocks of code just like…the stored procedures that we took a look at.…Now the difference,…and the reason we call these triggers,…is they are triggered. You got it.…By a preset action.…A log on or something like that.…A modification, a deletion.…So that action triggers this block of code.…Now triggers are controversial.…

Some people like them and some,…including your author, do not like them.…The reason I don't like triggers,…is that triggers are hidden.…That is, we can look at the code,…but when we fire the table,…then they can cascade out and…do all kinds of changes and I don't like that.…I like a clear path through my codes.…I can see Dre, call a, call b,…call c, call d…and I can look through the call stack.…

Triggers are, as I said, have the ability to…just get away and I don't like that.…There's some performance considerations.…Triggers can be less effective,…or that is use more resources than other…ways of doing the same thing.…But, that's not my main beef with them.…