[V4RB2] Finding in a VText

[Kem Tekinay]

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 )

__________________________________________________________________________
Kem Tekinay                                                 (212) 201-1465
MacTechnologies Consulting                              Fax (914) 242-7294
545 Eighth Avenue, Suite 401                          Pager (917) 491-5546
New York, New York 10018                    http://www.mactechnologies.com

To join the MacTechnologies Consulting mailing list, send an e-mail to:
  mactechnologies_consulting-subscribe at yahoogroups.com