Subject Re: [firebird-support] Re: it's possible to have a view cache?
Author Mark Rotteveel
> but what i want is to recalculate the view/second table only when the last
> row of the block is inserted (or equivalent when the transaction where
> them are isnrted has been committed).

Then use an ON TRANSACTION COMMIT trigger, see You will probably need something to check if the recalculation should actually be done, as this trigger will be triggered for every commit.

Populate a real table with data and update it in the trigger. That will probably the closest you can get to materialized views in Firebird.

Preisknaller: GMX DSL Flatrate für nur 16,99 Euro/mtl.!