Subject Re: [firebird-support] Good way to do...
Author Thomas Steinmaurer
>> - 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
> ....
> fieldn=xxx
> 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

With proper indices, you should be fine, even with a growing amount of

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.

With regards,

Thomas Steinmaurer
Upscene Productions

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!