Or, if you don't need an exact number of records, but just a count of
records inserted, create a generator for the purpose, increment it with a
trigger, but don't store the value anywhere!

Then, to get the count, do:
select gen_id(tablecountergenerator,0) from rdb$database;

Very quick indeed!

N.

> -----Original Message-----
> From: Hans Hoogstraat [mailto:hans@...]
> Sent: Thursday, 6 May 2004 9:59 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Count(*) on big tables
>
>
> 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
> |
> |
> |
> |
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>