Deian Popov wrote:

> Hello,
>
> I have large database (600MB +) with more than 1,6 million records in
> certain tables. In my opinion firebird is performing pretty bad on simple
> queries(database design is good, tables are normalized to the maximum,
> proper indexes are implemented, server machine is good). Can anyone share
> tunning tips or point me to any resource available on the internet.
>

Better to move this question to firebird-support.

1.) Not always normalization means best performance :)
2.) Show us the problematic query, and the used plan, as as much
information as you could about the envolved tables metadata.

see you !

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