Do not bid on this if you are not a full time MYSQL professional.
We have three databases with eight, one, and one million products. When using the search function the result is very poor.
We are using MATCH.
If we do a search for the movie: "There will be blood."
We get results showing:
The Blood Song
The reason is that MySQL is ignoring "will" and "be"
The search takes around 30 seconds.
We want to get suggestions on how to improve our search results and speed up the search. You will start on one of the smaller databases and then if you solve that one you will get the other two as well.
Please bid for one job here.