No not 50 million, although if the user is able to define the search
criteria it might happen.

I was speaking more general about why counting records is something you
might want to do.

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.

-
SMN

> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: 6. maj 2004 13:03
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] Count(*) on big tables
>
> At 01:27 PM 6/05/2004 +0200, you wrote:
> >When you want to make a decent user interface with scrollbars that
> >actually reflects the amount of data and/or display progress status
> >then it is necessary to know the record count.
>
> Really? 50 million records in a scrolling interface?
>
> /heLen
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Make a clean sweep of pop-up ads.
> Yahoo! Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>