Why not write a stored procedure and only do the recalculation if you
pass a particular value for a parameter?

Set

--- In firebird-support@yahoogroups.com, "kaczy27" wrote:
> --- In firebird-support@yahoogroups.com, Lucas Franzen wrote:
> >
> > Kaczy,
>
> > Deactivating a trigger is anything BUT multiuser safe.
> >
> :),
> ok, point taken,
>
> since it is the speed not the space that is important I guess I'll
> invest into another column in a million record table, or perhaps
> I'll create another table just to store the records that need to be
> recalculated and store the trigger there. It will break somewhat the
> design, but still what for one would need a design if the instance
> doesn't work.
>
> Thank you all very much for your input.
>
> > Luc.
>
> CUIN Kaczy