Search in Text fields

[Ruslan Zasukhin]

On 9/1/06 1:03 PM, "Pierre Rossel" <prossel2 at myrealbox.com> wrote:

Hi Pierre, 

>> It (Collation) can be changed at runtime, but you should avoid do this
>> often before each
>> query, because this change require rebuild of index for
>> db/table/field.
> 
> 
> This is what I was afraid of.

Note is possible to make e.g. Table Methods that have other settings so they
will produce other indexes. But this can be done of course for some hot
fields only to avoid overhead.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]