Subject | Re: [firebird-support] Count(*) on big tables |
---|---|
Author | Elmar Haneke |
Post date | 2004-05-06T06:31:49Z |
Hans Hoogstraat schrieb:
updating the counter!
Elmar
> It is much faster to maintain an additional 'counts' table, updated by theBeware of transactions here. Concurrent Inserts/Deletes might block on
> 'after insert' and 'after delete' triggers
updating the counter!
Elmar