Timothy Madden wrote:

> I do not understand the problem here, how long does Firebird need to do
>
> SELECT Count(*) FROM InvoiceItems;
>
> in the worst case, anyway ?
>
> I can't imagine Firebird doing a sequential scan of the table for that,
> really !

Maybe you should try implementing this feature yourself, and then you'll
see how 'simple' it is.

I'm sure developers would welcome a patch for this 'easy to solve'
problem. ;)

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com