3 ms·
Check constraints and foreign key constraints will save your bacon. I don't like triggers though, as a rule. Not that they are always the wrong thing, but its
by ams6110 9y ago
Check constraints and foreign key constraints will save your bacon.
I don't like triggers though, as a rule. Not that they are always the wrong thing, but its easy to kill performance with them, and just generally having "behind the scenes" side-effects triggered by other operations can be surprising, to say the least.
- mdpopescu 9y agoYou might want to look at [1]; you can send a message to a queue and process that independently. It breaks transactional boundaries though (if you abort the transaction the message is still in the queue). Using transactional queues will probably not help because then the transaction has to wait for the message to be processed so you're back to square one. [1] http://www.madeiradata.com/service-broker-asynchronous-triggers/ http://www.madeiradata.com/service-broker-asynchronous-trigg...