Subject | Re: [IBO] Help!!! TwwIncrementalSearch slow with TIBOTable |
---|---|
Author | Jason Wharton |
Post date | 2003-12-22T22:37:55Z |
> I've been pulliing my hair out over this one.Do you have a descending index set?
>
> I imported a very large dataset (450K rows) into FireBird, Advantage
> Database Server (ADS) and dbISAM.
>
> Next I indexed the key field VARCHAR(100)
>
> Now I know there is an IBO Increment Search Control but I need some
> other features of InfoPower not present in IBObjects so I need to
> use TIBOTable.
>
> So I set up
>
> IB_Connection--> TIBOTable--> TwwDatasource -->
> TwwDBIncrementalSearch
>
> With dbISAM and ADS respoonse is nearly instant. With FireBird +
> IBO it takes as much as 60 seconds. The SQL monitor show Forebird
> Scanning he ful table to find the closest record.
>
> I have an index set
>
> Help!!!!!!!!!!!!!!!!!!!!!!!!!
>
> I really want to use Firebird and IBO but this is a show stopper.
Jason