my bad. I was running query thinking that I have index, but found out I
didn't. FB runs lightning fast. case closed, thanks for comments.

On Feb 15, 2008 4:58 PM, Alexandre Benson Smith <iblist@...>
wrote:

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

[Non-text portions of this message have been removed]