-
Maitrayi Sabaratnam authored
A trigger may execute many trigger operations, eg. a foreign-key-parent may perform operations on matching child table rows. A base table row operation may execute many triggers and it is usual that the row operations are executed in batches. Trigger execution can be immediate or deferred where deferred executes all triggers at pre-commit. Executing high number of trigger operation concurrently may overload the node resources, causing job buffer full or send buffer full and leading to node crashes. This is fixed by limiting the number of concurrently executing trigger operations and outstanding fire-trigger requests per transaction.
Maitrayi Sabaratnam authoredA trigger may execute many trigger operations, eg. a foreign-key-parent may perform operations on matching child table rows. A base table row operation may execute many triggers and it is usual that the row operations are executed in batches. Trigger execution can be immediate or deferred where deferred executes all triggers at pre-commit. Executing high number of trigger operation concurrently may overload the node resources, causing job buffer full or send buffer full and leading to node crashes. This is fixed by limiting the number of concurrently executing trigger operations and outstanding fire-trigger requests per transaction.
Loading