Delayed or Asynchronous DML Trigger Execution
3
votes
1
answer
897
views
I have created a DML trigger (AFTER INSERT, UPDATE, DELETE) on a table
Trigger's logic takes about 30 seconds to execute
So if you change even 1 row, it takes ~ 30 seconds due to trigger execution
Developer asked me "Is there a chance that the trigger could be a fire & forget action?"
I said no, but is it really so ?
*Question:*
Can trigger be executed in "asynchronous" mode?
Application updates couple of rows in few ms, and thinks that transaction is completed, and then trigger is silently executed under the hood ?
I understand that this actually does not look good from consistency point of view, but still, is it possible ?
Asked by Aleksey Vitsko
(6195 rep)
Feb 22, 2021, 12:37 PM
Last activity: Feb 23, 2021, 04:09 PM
Last activity: Feb 23, 2021, 04:09 PM