Subject Re: SELECT COUNT(*) ... - slow
Author yeohray
--- In ib-support@y..., Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:
> Welcome to the world of client/server, Yeoh - or maybe it is only
> Firebird/Interbase (I have no experience with other c/s databases).
> desktop databases IB/FB have nowhere to store the number of
records ...

Actually, I was just wanted to know how many records I had in my
tables for general knowledge. My experience with SQL Server and
Oracle so far has been that such a query usually completes very fast
(SQL Server has a system table you can query if you want, that stores
the approximate number of rows in the table). Perhaps it's due to
the multi-generational architecture of Firebird.