Drop down suggestions (MySQL speed)
From: <bit-naughty_at_hotmail.com>
Date: Mon, 15 May 2017 18:05:09 -0700 (PDT)
Message-ID: <cc20848c-f195-4e91-b656-fb6464c5b6fa_at_googlegroups.com>
[Quoted] [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?
Date: Mon, 15 May 2017 18:05:09 -0700 (PDT)
Message-ID: <cc20848c-f195-4e91-b656-fb6464c5b6fa_at_googlegroups.com>
[Quoted] [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. Received on Tue May 16 2017 - 03:05:09 CEST