On 2/26/2015 2:03 PM, Merlin Moncure wrote:
> I would strongly advise you not to put complex processing in triggers
> if at all possible. Instead have the insert operation write a record
> into another table which forms a queue of work to do. That queue can
> then be walked by another process which accumulates the work and takes
> appropriate action (and, since you are out of the context of the
> operation at hand, can be threaded etc).
I 2nd this emotion... that's exactly what we do with our complex
background processing.
--
john r pierce 37N 122W
somewhere on the middle of the left coast