Smokie commented on a Page, Autocomplete Server-side Component with mySQL and JSON results using Express.js  -  Apr 12, 2016

Searching with LIKE can be really slow. It would be better to check if term's length is enough to use FULL-TEXT. And if else use LIKE instead.

 Respond  
Are you sure you want to unfollow this person?
Are you sure you want to delete this?
Click "Unsubscribe" to stop receiving notices pertaining to this post.
Click "Subscribe" to resume notices pertaining to this post.