Re: Drop down suggestions (MySQL speed)

On 5/15/2017 9:05 PM, bit-naughty_at_hotmail.com wrote:
[Quoted] > If I want to have drop down suggestions on a website (like Google does), with the actual suggestions coming from a MySQL table - is MySQL fast enough to handle such things? Like, if some one types "gr", it has to a SELECT FROM table WHERE term = "gr" - is the whole thing, reading from disk included n all, fast enough so that the suggestions will drop down INSTANTLY when "gr" is typed? Any tips n tricks on how to achieve this?
>
>
> Thanks.
>

Nothing will be "instant" - especially when it requires a trip to the server and back.

[Quoted] Google uses a heavily modified version of MySQL to set up its results. As for your database, it depends a lot on how big the database is. If you have 1K rows, retrieval can be pretty fast. However, if you have 1G rows, retrieval will be much slower.

[Quoted] [Quoted] So in answer to your question, there is no answer. You haven't provided sufficient information for an intelligent response.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex_at_attglobal.net
==================