I don't think you can. The 3 seconds for subsequent counts is the result of
caching.


-----Original Message-----
From: williamvdw2004 [mailto:williamvdw2004@...]
Sent: Sunday, February 27, 2005 11:44 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Performance of the count Function.




I have a table with about 630 000 records. I do the following count
query. select count(transactionkey) from account.

This query takes about 30 seconds the first time and 3 seconds
subsequently. Transactionkey (bigint) is defined as the pimarykey of
the table I have also added a descending index to the transactionkey
column, page size is 8192. If I change the query to count the rows
in the backup table the same thing 30 seconds the first time and 3
seconds subsequently. Is there anything I can do to speed this up
(the first query?)

Thanks in Advance
William








Yahoo! Groups Links