- September 20, 2016 at 9:06 am #10191
Hi, I am having a few problem with the logic of the search. What i would like would be when a user puts in a number of key words e.g. fried chocolate yellow the search brings back the result that matches all of those keywords and then the ones closest matches follow.
Currently using the ‘Or’ logic its returns anything with those words and the ‘And’ logic doesn’t bring back any results.
Can you help please.September 20, 2016 at 10:00 am #10193
Unfortunately that is not possible yet. I know it sounds logical, but there is a huge performance issue with using two separate logics at the same time, which I’m not able to solve yet. Matching all keywords, then partial matching requires two separate queries to be executed – exponentially increasing the response time.
I’m working on a solution to allow a secondary logic as you described, but it requires lot of testing, so it runs smoothly on most user servers.
I would also recommend checking the Index table engine. The “and” logic is much different (more effective) with it, as it can match across multiple fields at once.Best,
If you like my products, don't forget to rate them on codecanyon :)
September 20, 2016 at 10:15 am #10194
Thank you for your quick response. I will try the index table engine.
Good luck with the secondary logic solution.
You must be logged in to reply to this topic.