I'm experiencing the same thing.
The solution I had was to maintain a table of counts, and update this table
accordingly via use of triggers.

Regards
Kenneth

----- Original Message -----
From: "yeohray" <yeohray@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, April 05, 2002 9:21 AM
Subject: [ib-support] SELECT COUNT(*) ... - slow


> I have a table with 1 million+ records. When I ran a query to count
> the number of records e.g. SELECT COUNT(*) FROM MyTable, the query
> took about 20 seconds to complete. Is there any way to speed these
> sort of things up (maybe a system table somewhere?)?
>
> Thanks in advance.
>
> Yeoh
>
> Specs:
> Win2000 Professional
> AMD Duron 800
> 192MB RAM
> Firebird 1 Beta 2 (clients are still using IBO :)
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>