Kem Tekinay have found that FindContains is not fast enough. We was able speed up this place x10 times. Indexed search on table with 7 million rows have go down from 46 sec to 4.6 sec.
You can get this using
- API – VField.FindContains()
- SQL – WHERE LOCATE( “what”, fld ) <> 0