--- In firebird-support@yahoogroups.com, "Svend Meyland Nicolaisen"
<news@s...> wrote:

>
> > -----Original Message-----
> > From: Tim Ledgerwood [mailto:tim@s...]
> > 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.

And usually, when result set is reasonably small and records do'nt
contain char(32000), fetchall solves the problem.

Best regards,
Alexander.