These are names&titles of Americans. This web app and database do not
exist now (the current procedure is done with more primitive tech), and so
I can make plausible adjustments to the plan.
Thanks
Mike Spreitzer/Watson/IBM
09/21/09 04:10 PM
To
"Jerry Schwartz" <jschwartz@stripped>
cc
"'Michael Dykman'" <mdykman@stripped>, mysql@stripped, Mike
Spreitzer/Watson/IBM@IBMUS
Subject
RE: incremental name search?
Ah, yes, I forgot to describe the server and the load. Suppose my web app
and MySQL are done via shared hosting by some common hosting business. I
do expect multiple people to be using my web app, but generally only one
(usually zero, sometimes one, maybe occasionally a few) at a time. Is
this going to fly, in terms of latency for the incremental lookups and
overall load at the hosting site?
Thanks
"Jerry Schwartz" <jschwartz@stripped>
09/21/09 03:47 PM
To
"'Michael Dykman'" <mdykman@stripped>, Mike Spreitzer/Watson/IBM@IBMUS
cc
<mysql@stripped>
Subject
RE: incremental name search?
SoundEx doesn't do much for names, or non-English words for that matter.
Although you could use AJAX to handle the web part of this, I can't
imagine it
being able to handle much of a load. I think you'll beat the system to
death,
to little avail.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
>-----Original Message-----
>From: Michael Dykman [mailto:mdykman@stripped]
>Sent: Monday, September 21, 2009 12:21 PM
>To: Mike Spreitzer
>Cc: mysql@stripped
>Subject: Re: incremental name search?
>
>Perhaps this could help you out..
>
>http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_soundex
>
> - michael dykman
>
>On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer <mspreitz@stripped>
wrote:
>> Suppose I have a table of a few thousand people, with a FirstName field
>> and a LastName field. Sadly, my people are not so regular. Some names
>> have three parts (e.g., due to marriage) crammed into the two fields
>> ("Hillary Rodham Clinton"). Some even have titles ("Dir, gastroent.
>> dept., Fubar hosp. OurTown") wedged in there. I want to make a web app
>> that searches this table incrementally as I type into a web page in my
>> browser. I am thinking I will have to do something like continuously
>> display the top 10 matches to what I have typed so far. Of course,
when I
>> am typing I do not know exactly what is in the database. I generally
know
>> only some of the parts of the name when I am typing (e.g., I am looking
up
>> "Mary Jones" without knowing whether Jones is her maiden name).
Sometimes
>> I am even typing something that is a spelled a bit wrong ("Schiller"
vs.
>> "Shiller") or variantly ("Lizzie" vs. "Elizabeth"). This seems pretty
far
>> from what MySQL can do directly. I know about "LIKE" matching. I know
>> the wider SQL community has something called "soundex", but I have not
yet
>> found it in MySQL. I have a hard time imagining what will help me with
>> variants on a name. I do not see any easy way to find the "top 10"
>> matches. Am I missing anything that can help me here?
>>
>> Thanks in advance!
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>>
>>
>
>
>
>--
> - michael dykman
> - mdykman@stripped
>
>Don't worry about people stealing your ideas. If they're any good,
>you'll have to ram them down their throats!
>
> Howard Aiken
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>infoshop.com
