Reply To: Search Logic Issue


Ernest Marcinko


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.

Ernest Marcinko

If you like my products, don't forget to rate them on codecanyon :)