It is much faster to maintain an additional 'counts' table, updated by the
'after insert' and 'after delete'
triggers for tables or conditions you want to count or estimate in a
multi-user environment.

-------------------------------------------------

----- Original Message -----
From: "Jerome Bouvattier" <JBouvattier@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, May 05, 2004 8:44 AM
Subject: [firebird-support] Count(*) on big tables


| Hello,
|
| I know Count(*) requires a full scan and can't return immedialtely. But
| isn't 8 minutes a bit too much for a 50 millions rows table ?
|
| The first time, I thought it was due to GC, but subsequent calls took as
| long.
|
| Any hint ?
|
| Thanks.
|
| --
| Jerome
|
|
|
|
|
| Yahoo! Groups Links
|
|
|
|