Andreas wrote:
Am 21.11.2005 um 18:00 schrieb [EMAIL PROTECTED]:
Those are really database issues. Asking on one of the 4D lists might
reveal more answers.
Yes I will try it - I assumed here are the webshop people :-)
Can you be more specific about what you want to do?
Will you be searching indexed alpha fields or against text fields?
I want to search (no find) strings (possible wrong written) in
textfields.
How large is the target DB?
in about 10 000 records
Andreas,
I assume that you would be trying to find important words that your
users commonly misspell?
So given for example "Andreas" you'd need to know what the common
misspellings are. That is going to require some type of a dictionary
lookup, or implementation of an algorthm, that will generate possible
misspellings. So if there are 7 common mispellings for Andreas you'd
need to search your text field for each of them. Obtaining/developing a
dictionary or finding an algorithm that you can implement, in my
opinion, will be the tricky part.
If the DB won't grow much doing a sequential text search on 10K records
might give you acceptable search performance, but you wouldn't want to
use native 4D "contents" searches. You will want to either write or
obtain a 4D method that implements Boyer-Moore text searching to find
the misspelling. There are B-M examples in an old 4D technote (search
www.4d com) that has probably been tweaked and posted elsewhere (See
www.4dzine.com's Tips & Tricks system, or possibly www.4dtoday.com) or
ask on the NUG. There may also be one or more plug-ins that implement
B-M searches (try http://www.pluggers.nl/api_pack.html). If you go the
4D code route, I'd suggest putting the code in a 4D method and not try
to implement it in Active4D. Compiling the method will definitely give
you a speed boost.
The other option would be to approach this problem differently and
install spell checking in our database. I think 4D provides it natively
now (I don't use it), plus there is at least 3rd Party one plug-in.
hth,
Brad
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
