Subject Re: [firebird-support] Good way to do...
Author Vander Clock Stephane
> - How many distinct contact ids do you expect

around 100 000

> - How does your query pattern look like?

select xxx from table BIGTABLE where
contactID=xxx and
fialdA=xxx and
order by fieldw

> Because of latter, is contact id the only criteria for filtering rows or
> are there more (e.g. date/time, product etc ... information)?
no, much more criterias than just contact ID

> You always can work with an archive and "most recent" table (maintained
> by triggers), in case of performance slow down due to increasing data
> volume. This, possibly is in relationship with your query pattern as well.

i already do like this and this gave me 80 000 000 reccords table :(

thanks for all Thomas

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