At 02:39 PM 11/27/2004, kartinku wrote:

>My database size has grown to 1.28GB .
>
>Is 'count(*) query performance' goes down when record count increases?

Yes. Linearly. Counting the records in a table requires reading
every record. The more records, the more reads. This topic has
been discussed (ad nauseum) on this list. If you seriously need
to keep a count of records, several alternatives have been described
which reduce the cost.

>Since firebird maintains the data in single won't it degrade db
>performance.

If you want to get parallelism in disk access, you might consider
a hardware assist. You can split a firebird database into separate
files but you can not direct the storage of records to files.

Regards,


Ann