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 :)