Subject Re: [firebird-support] Count(*) on big tables
Author Elmar Haneke
Hans Hoogstraat schrieb:
> It is much faster to maintain an additional 'counts' table, updated by the
> 'after insert' and 'after delete' triggers

Beware of transactions here. Concurrent Inserts/Deletes might block on
updating the counter!

Elmar