FindContains() speed improved x10 times

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

Published by

Ruslan Zasukhin

VP Engineering and New Technology Paradigma Software, Inc