Sample Header Ad - 728x90

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