I can provide the plan output Monday next week. I can explain approx. table
structure:

id : int PK
col1 varchar(12)
impdate DATE
some other cols (no blobs)

I have index on impdate(it's not unique). If I call SELECT ... FROM ....
WHERE impdate=<somedate> it may take up to 8 seconds to fetch the records
for that specific period. I'm sure it uses the index.

On Fri, Feb 15, 2008 at 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]