|Subject||Re: [firebird-support] Good way to do...|
|Author||Vander Clock Stephane|
> - How many distinct contact ids do you expectaround 100 000
> - How does your query pattern look like?select xxx from table BIGTABLE where
order by fieldw
>no, much more criterias than just contact ID
> Because of latter, is contact id the only criteria for filtering rows or
> are there more (e.g. date/time, product etc ... information)?
> You always can work with an archive and "most recent" table (maintainedi already do like this and this gave me 80 000 000 reccords table :(
> by triggers), in case of performance slow down due to increasing data
> volume. This, possibly is in relationship with your query pattern as well.
thanks for all Thomas
[Non-text portions of this message have been removed]