Search Logic Issue

This topic contains 2 replies, has 2 voices, and was last updated by albert123 albert123 5 years, 11 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #10191
    albert123
    albert123
    Participant

    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.

    #10193
    Ernest Marcinko
    Ernest Marcinko
    Keymaster

    Hi,

    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,
    Ernest Marcinko

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


    #10194
    albert123
    albert123
    Participant

    Hi Ernest,

    Thank you for your quick response. I will try the index table engine.

    Good luck with the secondary logic solution.

    Regards
    Chris

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.