Subject | Re: [firebird-support] Re: If Not SELECT COUNT(*), Then What? |
---|---|
Author | Woody |
Post date | 2008-12-18T19:54:47Z |
From: "Dimitry Sibiryakov" <sd@...>
approximate count of the number of transactions I've had at my bank last
month, I want an exact one.
Using the statistics can only get you close. When you are running a report
that has to show statistical information for whatever reason, an approximate
count just doesn't cut it.
When you're showing a progress bar, sure, it doesn't really matter as much,
but there are many legitimate reasons for needing an exact count.
Woody (TMW)
>> But please, do not discount nor alienate those of us who use itYou can't get an accurate count, that's the point. I don't want an
>> legitimately
>> because there is no other way to get the information needed.
>
> But, actually, there is. You can get approximate record count from
> statistic.
approximate count of the number of transactions I've had at my bank last
month, I want an exact one.
Using the statistics can only get you close. When you are running a report
that has to show statistical information for whatever reason, an approximate
count just doesn't cut it.
When you're showing a progress bar, sure, it doesn't really matter as much,
but there are many legitimate reasons for needing an exact count.
Woody (TMW)