Hi Victor,
VFP's SOUNDEX() is a native function - that means it's implemented in C(++), which in turn means that it's quite quick.
It should be fast enough for your requirements. You could even index on the SOUNDEX of the search field if you really wanted to.
Cheers,
Andrew
>Andrew,
>
> Did you test SOUNDEX() function on a 2.5 million records? I need a very fast phoentic search algorithm in order to achieve my requirement.
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.