> -----Original Message-----
> From: Tim Ledgerwood [mailto:tim@...]
> Sent: 6. maj 2004 13:19
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] Count(*) on big tables
>
>
> >
> >I respect that the architecture of FireBird (and any of its
> >counterparts) isn't optimal for counting records because of it many
> >other advantages. I just think that it isn't fair to say that record
> >counting is stupid and is of no use.
>
> No - record counting is very useful, and the user will often
> want to see the results of a count. BUT NOT counting a whole
> table - it makes little sense. What you will generally count
> is the rows in a result set - and it should be very much
> smaller than the number of rows in your primary table.
>
> In a multi user environment, a table is a dynamic thing. it
> doesn't make much sense to show "COUNT (*)", except under
> very specific circumstances.
>
> Regards
>
> Tim
>
>

I totally agree. And still "counting tables" of some sort as mentioned in
another post *can* improve application/UI performance in some cases.

-
SMN