Subject Re: [firebird-support] Additional resources needed.
Author Helen Borrie
At 05:26 PM 16/12/2003 +0000, you wrote:
>Hi there, I'm seeing very poor perfpormance with Incremental Search
>TwwIncremtnSearch --> TwwDataSource --> TIboTable --> IB_Connection
>it works fine with dbISAM (TwwIncremtnSearch --> TwwDataSource -->
>TdbISAMTable --> TdbISAMDatabase) and Advantage Database Server
>TwwIncrementalSearch --> TwwDataSource --> TAdsTable --> TAdsDatabase

Off-topic - this is an IB Objects question, which you have cross-posted.

>On a related note, I need to index on fields larger then 240 chars.
>How can I do this with firebird?

If you are using a 1-byte character set with its default (binary)
collation, the limit is 253 bytes. If you can't reach past 240, then it
will be one of "the index is compound" or "collate sequence is non-binary"
- both eat up some bytes from the limit.

>Please point me to sites or news groups where I'm likey to find more
>information on theses subjects.

ibobjects list is the right place for IBO questions.

Don't be surprised that what works with desktop databases doesn't work "out
of the box" with client/server. Different architectures, different UI