Submitted by: Daisson - JB Software (daissonjb)

Hi everyone.

It's my first time here, and I'm already posting new features, sorry!.

OK, imagine this scenario:

TABLEA (
ID (PK),
CUSTOMERID,
VLTOTAL,
VLTOTAL1,
VLTOTAL2)

TABLE B (
ID (PK),
IDTABLEA (FK),
IDPRODUCT,
VALUE,
VL1,
VL2)

The fields VLTOTAL1 and VLTOTAL2 of TABLEA are a SUM of VL1 and VL2 from TABLEB grouping by IDTABLEA.
Today I've an application that generate this SUM by trigger on AFTER INSERT of TABLEB, but this consume a lot of CPU, specially in cases that TABLEB have a thousand records. Another reason it's cause we use an script executing to insert several records in TABLEA and, of course, another several records in TABLEB.

Now, if we've an On Transaction Commit Trigger to TABLEB, the SUM would by execute once only in the end of this transaction. The ideia of this type of Triggers is the same as Database Triggers except that can be applied to a specific table.

Maybe, another approach would be an On Before Transaction Commit to use the same transaction isolation level to perform all of the commands. Or might be existis an On After Transaction Commit in case we've to do same operation in another table or another database (in FB 2.5) that's independ of the same transaction.

Thank you.

Daisson.