RE: Triggers?

I, too, recommend that trigger programs do the very minimum possible
amount of work. To that end, the trigger-based workflow script
functionality I recently added to our Wintouch product uses a
precompilation strategy that allows the trigger program to run a much
faster-executing script than what it would have to deal with otherwise,
and defers time-consuming functions to other programs running in separate
jobs.

Effectively, the only things a trigger should do are those it can't defer
(i.e., things that might cause a "before" trigger to veto an action, and
those that need to happen before control is returned to the user), or
those so fast that it's not worth deferring them.

--
JHHL