lynnfredricks.com

The Technology Tribe

Archive for the ‘API’ tag

Valentina FindContains () Massive Indexed Search Speed Increased

without comments

Ruslan and Valentina user Kem Tekinay wanted FindContain ( ) to be a little faster. The Valentina developer team  was able to speed this up by 10 times. Indexed search on table with 7 million rows has gone down from 46 sec to 4.6 sec.

You can get this using

  • API – VField.FindContains()
  • SQL –  WHERE LOCATE( “what”, fld ) <> 0

It is hard to go more than a single .1 release without some aspect of Valentina DB being optimized for speed.

Written by Lynn Fredricks

March 15th, 2010 at 8:16 am

Posted in Valentina

Tagged with , ,