[V4RB2] Finding in a VText

[Ruslan Zasukhin]

On 4/21/05 3:27 PM, "Kem Tekinay" <ktekinay at mactechnologies.com> wrote:

> I have about 25,000 records that include three VText fields. Those fields
> are indexed by words.
> 
> 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 )

Have you try IndexByWords ?

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