SOUNDEX

[Ruslan Zasukhin]

On 7/27/04 9:06 AM, "olivier" <vidal_olivier at yahoo.fr> wrote:

> Until soundex maybe a day implemented in Valentina, here is how I
> planned to make :
> 
> BoNameFamily :
> 
> - NameField (string, indexed)
> - NameSoundexField (string, indexed)
> 
> In every addition or import of Family Name, its soundex code is
> calculated is recorded in the field NameSoundex.
> 
> When the customer makes a search, it is enough to calculate the soundex
> code of the wanted  name and to compare it with fields nameSoundex of
> the table.
> 
> The field being indexed and as is a criterion of equality, the search
> for equivalent phonetic names should be very fast.
> 
> eg
> Search on "GROS"
> Calculation of soundex code of "GROS" -> code A456
> WHERE name="GROS"   --> WHERE nameSoundex="A456"
> 
> Finally, it is the calculation of the soundex code that is the longest,
> I think.
> 
> It is maybe the algorithm of calculation of the soundex that could be
> optimized in Valentina.
> At the moment, we have to make it with Realbasic (for example), who is
> maybe much slower than Valentina.


I think such way has no speed penalty as I see.

It will not slow down a lots your INSERTS.

And search absolutely will not be slow down.
    you once calculate code in RB, and then vl use it for search in million
of records.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------