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.

--
eat(this); // delicious suicide