Jonathan wrote:

>Why is the "select count(*) from tablename" run slow in firebird ?
>
>Is there anyway to improve this ?
>
>

Jonathan,

This is a topic discussed a lot of times here.

Take a look on the message history and you will get a very detailed
information about this issue. "Why it happens this way", "How you could
make it better" and some questions about "Why did you need it".

if you didn't find usefull messages post again and we try to point you
the relevant threads.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.3.2 - Release Date: 31/05/2005