Search results

This topic contains 1 reply, has 2 voices, and was last updated by Ernest Marcinko Ernest Marcinko 4 years, 10 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #14208
    rocketseo
    rocketseo
    Participant

    Hello!
    We have installed the Ajax Search Pro plug-in.
    We set up the search form, but we see two problems:
    1. the search does not produce correct results for the filter Exact matches
    2. it takes the search very long to load, i.e. the search lasts a very long time.
    Could you please provide any recommendations for optimizing the performance, to reduce the searching time?
    Thank you.

    #14210
    Ernest Marcinko
    Ernest Marcinko
    Keymaster

    Hi,

    Thank you for the details!

    2. Performance
    The issue was, that your database contains a huge amount of content, and the database server was not able to look for matches faster.

    Since you give access, I have made a few adjustments, to improve the performance greatly:
    – I enabled and generated the index table engine. It greatly helps to increase the performance and speed. It indexed over 500 000 keywords: https://i.imgur.com/5Ld5IVL.png
    – Also enabled the custom ajax handler: https://i.imgur.com/IG2m6Zu.png

    These resulted in a 25x increase of performance. You can read more about performance improvements on this documentation article: Improving search performance

    The search should have now a much better performance.

    1. Exact matching
    I would not recommend using that option in your case – as it automatically uses the Regular engine (instead of the Index table), which will greatly decrease the performance.
    In your configuration the main and secondary keyword logics are set exact word matching, which is much more precise with the current configuration as the exact matching: https://i.imgur.com/14mi7vk.png
    Exact matching checks if the content, title etc.. contains the keywords exactly as entered – regardless if it’s within the content or anywhere else, therefore it’s slower, and cannot use the index table, as it has to search the posts table – which is not optimized for searching.

    Related documentation links:
    Index table engine
    Search performance and Improving search performance

    Best,
    Ernest Marcinko

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


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

You must be logged in to reply to this topic.