[V4RB2] Finding in a VText

[Ruslan Zasukhin]

On 4/21/05 4:18 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

>> I have about 25,000 records that include three VText fields. Those fields
>> are indexed by words.

I see now. 

Well, really very long.

Please send me project that reproduce

 
>> I find that a FindContains on those fields takes a long time (15 to 30
>> seconds), even though I am just searching for one word. But if I go into
>> VStudio and use " select * from email where bodytext like '%viagra%' or
>> bodyhtml like '%viagra%' or bodyenriched like '%viagra'", the search takes
>> about 5-10 seconds (still longer than I'd expect, but better).
>> 
>> Using FindValue finds nothing at all.
>> 
>> What am I missing?
>> 
>> My code is this:
>> 
>>       bs = zEmailTbl.fldBodyText.FindContains( term )
>>       bs1 = zEmailTbl.fldBodyEnriched.FindContains( term )
>>       bs = bs.Union( bs1 )
>>       bs1 = zEmailTbl.fldBodyHTML.FindContains( term )
>>       bs = bs.Union( bs1 )


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