On Wed, Oct 1, 2008 at 2:59 PM, Daniel Albuschat <d.albuschat@...> wrote:

>
> 2008/10/1 Timothy Madden <terminatorul@...>:
>
> > I do not understand the problem here, how long does Firebird need to do
> >
> > SELECT Count(*) FROM InvoiceItems;
> >
> > in the worst case, anyway ?
>
> Five hundred years.
>
> > I can't imagine Firebird doing a sequential scan of the table for that,
> > really !
>
> Yup, it does. And actually it's good that it does because it keeps developers
> from using this, since most of the time it is simply unneeded or plain wrong.
>
> You have to make your program work on an unknown size of records. There's
> no way to avoid that. And that's exactly what I was trying to solve in the best
> imaginable way from a usability standpoint.

To answer the original question, I use fbembed.dll with FBLib and Delphi.

This SELECT Count(*) problem is really incredible. I can understand concurent
transactions see different versions of the same table. Why is it
difficult for every
of these versions to also have their own row count ?

Thank you,
Timothy Madden