I would like to get some ideas on how I can create an efficient MySQL database that can handle high-traffic autocomplete requests, such as the Google auto-SERP auto-update feature.
The key to this is, I am trying to take the contents of my book, and I want to index the text so that the database requests the appropriate text in the least amount of time.
Example:
If I typed in the text “how” , I would essentially look at the database (the entire book) and see a result set for sentences in the book that say:
"...that is as I was saying..."
"as I intended..."
"This is as good as it gets"
...
But as soon as I type “k” and he says “ask,” the result set will change to (i.e.):
"Ask your father..."
"...I will ask you to do this."
...
In addition, I considered adding auxiliary words, so if you are in the middle of the input “askew” but currently only “ask” , the database will capture all the words containing “ask” , you will see auxiliary words, such as "ask," "ask," "ask," "ask . "
, , . , 2, .
- , - . , , .
- ? , ?
, ajax- ... , . , , , script , . , .
- 1... , , "two_letters", "three_letters" ..
"two_letter" "" , " " , "" ... :
"as", "125"
"as", "2024"
"as", "4"
, , . , ! 2- , . , 3- , . , .
script . , .
, , , Google SERP. , " " , :
"they are gone already..."
"they are going to the movies later."
"how they are gonna get there is..."
Google, - , - .
, , , , !:)
.