Can't test on FB now, but just tested on IB 5.6 on a table with some 8
million rows and it took 12 secs.

RBS

> 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 !
>
> Thank you,
> Timothy Madden
>
>
> [Non-text portions of this message have been removed]
>
>