|Subject||Re: [firebird-support] Re: trying to avoid large datasets|
>I think it is easier to take one of the existing routines an put it into an UDF.
> would i be better off writing it as a udf or a stored procedure?
What Adam wrote does make sense though, so give it a try on how long it takes to compare all your
existing entries with the one just being entered.
Unfortunately, with the Levensthein Distance one cannot prepare the existing records but has to make
the comparison anew whenever another entry is added.
Maybe you can limit this search to those entries with the same artist/band?