|Subject||Re: [firebird-support] Good way to do...|
>> - How many distinct contact ids do you expectWith proper indices, you should be fine, even with a growing amount of
> 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
Mind you, creating an index on a table needs exclusive access to the
table, which can take some time on a huge table. A larger temporarily
page cache for index creation might help to decrease execution time.
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server