Subject Re: [firebird-support] Re: If Not SELECT COUNT(*), Then What?
Author Woody
From: "Ann W. Harrison" <aharrison@...>
> The real crime against Firebird is not a well qualified count - we
> tend to be not much slower than other databases when there are
> indexed terms and about the same when there are a combination of
> indexed and non-indexed terms in the where clause for a count.

Exactly. And in most cases, at least for me, the additional time for the
counting is offset by the time it takes to print a report anyway. The user
really doesn't notice any difference and trust me, I do lots and lots of
reports that require statistical production results. If there were problems
with speed, I'd be the first to hear about it. With well structured tables,
indexes, etc., I've never noticed any count taking longer than a few seconds
and that's nothing to worry about, IMO.

Woody (TMW)