--- In firebird-support@yahoogroups.com, "RB Smissaert"
<bartsmissaert@...> wrote:

>
> > Did you ever meet a real person that would use such application and
> > scroll through 8 million records?
>
>
>
> No, so for that reason and also not to waste time I only will do a full
> table dump if the number of rows is not too big.
>
> As said, all nicely solved now.

If you are doing a full table dump, you do not need a record count.
You simply process the records until such time the DBMS informs you
there are no more.

Milan's point makes perfect sense. We have several tables with well
over a million records in the databases belonging to some customers.
It would be utterly pointless to display all the records in a grid. I
mean we could do it, but holding down the page down key would take
over 15 minutes to it the bottom.

In terms of progress bars or determining record counts by scroll bar
height, you don't need an accurate figure. You need a ballpark
estimate. I certainly wouldn't object to some system view or
monitoring table that pretty much did Ivan's little trick for such
purposes.

Adam
PS. In answer to the actual question behind the thread
Delphi + our own data access layer that currently uses IBX
(TIBDatabase, TIBTransaction, TIBQuery and TIBSQL as required).