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" <jschwa...@the-infoshop.com> 09/21/09 03:47 PM To "'Michael Dykman'" <mdyk...@gmail.com>, Mike Spreitzer/Watson/i...@ibmus cc <mysql@lists.mysql.com> 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:mdyk...@gmail.com] >Sent: Monday, September 21, 2009 12:21 PM >To: Mike Spreitzer >Cc: mysql@lists.mysql.com >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 <mspre...@us.ibm.com> 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=mdyk...@gmail.com >> >> > > > >-- > - michael dykman > - mdyk...@gmail.com > >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=jschwa...@the- >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
