Re: Drop down suggestions (MySQL speed)
From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Thu, 18 May 2017 08:05:38 +0100
Message-ID: <ofjgtp$tji$1_at_dont-email.me>
>
> Sorry - what do you mean? If someone types "sh", and the suggestion has to be "shit", I can't start searching until someone TYPES the "sh", can I?
>
Exactly. BUT the question is, is that searching done by downloading the entire dictionary into the browser so you can let JavaScript handle the search inside the browser, or will you go back to the server every time he types a character and do the search there and then download a modified section of page and insert it?
Date: Thu, 18 May 2017 08:05:38 +0100
Message-ID: <ofjgtp$tji$1_at_dont-email.me>
On 18/05/17 07:58, bit-naughty_at_hotmail.com wrote:
> On Tuesday, May 16, 2017 at 5:26:32 AM UTC, The Natural Philosopher wrote:
>
>> >> well as long as you know IN ADVANCE what you want to drop down, yu can >> drag it from a table when the whole page is built,
>
> Sorry - what do you mean? If someone types "sh", and the suggestion has to be "shit", I can't start searching until someone TYPES the "sh", can I?
>
Exactly. BUT the question is, is that searching done by downloading the entire dictionary into the browser so you can let JavaScript handle the search inside the browser, or will you go back to the server every time he types a character and do the search there and then download a modified section of page and insert it?
If there are limited choices you will generally do the former. If massive choices the latter., and accept the speed penalty, which is probably NOT the machine cycles at the far end, but the transfer delays across the internet.
-- Outside of a dog, a book is a man's best friend. Inside of a dog it's too dark to read. Groucho MarxReceived on Thu May 18 2017 - 09:05:38 CEST