3 ms·
> There are some downsides. Triggers are very hard to debug, optimize and monitor. That's enough for me. My heart always sinks when in response to a problem so
by weavie 8y ago
> There are some downsides. Triggers are very hard to debug, optimize and monitor.
That's enough for me. My heart always sinks when in response to a problem someone suggests a solution of "let's just stick a few triggers in"..
Its happened too many times in my career where some wierd problem that noone can work out turns out to be caused by a trigger that noone realised was there.
- doh 8y agoI do understand. Triggers are ripe for improvements. We have some internal tools built around them, but nothing significant. Most helpful are protocols for humans to follow when dealing with a problem. Always start with the trigger. At the same time, triggers saved us hundreds of thousands of lines of code and extremely complicated logic, that would be required would we wanted to replace them.