Subject | Re: SELECT COUNT(*) ... - slow |
---|---|
Author | yeohray |
Post date | 2002-04-05T13:33:34Z |
--- In ib-support@y..., Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:
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.
Yeoh
<svein.erling.tysvaer@k...> wrote:
> Welcome to the world of client/server, Yeoh - or maybe it is onlyUnlike
> Firebird/Interbase (I have no experience with other c/s databases).
> desktop databases IB/FB have nowhere to store the number ofrecords ...
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.
Yeoh