>
>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


[Non-text portions of this message have been removed]