List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:September 21 2009 9:29pm
Subject:RE: incremental name search?
View as plain text  
Beyond being leery of the whole project, I can't really say how well or poorly 
it would work. You are, after all, talking about at least one query per 
keystroke. On top of that you're going to be doing some tricky stuff in a PHP 
(or some such) back-end, to figure out what query to use - again, one 
execution per keystroke.

It doesn't matter if it's only one user, if they type fast enough it will 
generate many server hits: several per second, I should think.

I wonder how Google handles their search suggestion gimmick - I never gave it 
much thought. That's as close as I can come to a similar application, off the 
top of my head.

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: Mike Spreitzer [mailto:mspreitz@stripped]
>Sent: Monday, September 21, 2009 4:11 PM
>To: Jerry Schwartz
>Cc: 'Michael Dykman'; mysql@stripped; Mike Spreitzer
>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
>
>
>
>
>




Thread
incremental name search?Mike Spreitzer21 Sep
  • Re: incremental name search?Michael Dykman21 Sep
    • RE: incremental name search?Jerry Schwartz21 Sep
      • RE: incremental name search?Martin Gainty21 Sep
      • RE: incremental name search?Mike Spreitzer21 Sep
        • RE: incremental name search?Jerry Schwartz21 Sep
          • RE: incremental name search?Gavin Towey22 Sep
RE: incremental name search?Mike Spreitzer21 Sep
  • RE: incremental name search?Jerry Schwartz21 Sep