Loose search

[Ruslan Zasukhin]

On 4/17/05 8:33 PM, "jda" <jda at his.com> wrote:

>> 
>> 
>>     WHERE fld LIKE '%str%'
>> 
>> Starting from 2.0.3fc1  LIKE even can do INDEX SCAN, so this is very fast
>> 
> 
> And REGEX?

Yes

All depends of course on which data you have.

For example for Kem, LIKE now works in 20 times faster



-- 
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]