Slow Search Consultation?

This topic contains 5 replies, has 2 voices, and was last updated by Ernest Marcinko Ernest Marcinko 1 month, 3 weeks ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #40422
    smittelstaedt09
    smittelstaedt09
    Participant

    Our magazine site has about 39,000 posts and growing.
    Our search results are very slow, and my manager has pleaded with me to find an alternative search system to make us more “google” fast.

    My gut feeling is that I’m missing something in the config that could make AjaxSearchPro faster.
    I’ve spent a fair amount of time drilling through your documentation screen by screen…and I guess I don’t know what I don’t know. 🙂

    A) Is your plugin capable of efficiently handling 40,000 to 50,000 posts or am I asking too much of your awesome plugin?

    B) Are you available to consult/check the performance?
    I can set up a super-admin account in our DEV site for testing.

    Search queries tracked: 154557
    Average request runtime: 5.930 s
    Average request peak memory usage: 25.71 MB
    Last request runtime: 15.000 s
    Last request peak memory usage: 34 MB

    #40434
    Ernest Marcinko
    Ernest Marcinko
    Keymaster

    Hi,

    In your case I would strongly recommend using the index table engine feature. That alone will make the search a lot faster, especially if you have a lot of posts to search for. That number of posts should not be an issue, we are regularly testing on a database with 100 000 posts.

    Once you have configured and generated the index, then make sure to to enable it, and that’s it. After that your seach queries should be a lot faster.

    Best,
    Ernest Marcinko

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


    #40446
    smittelstaedt09
    smittelstaedt09
    Participant

    Thank you for the quick response.
    That’s good to know you’ve tested up to 100K posts…very encouraging.

    Yes, I’ve had the index table set up from the start.
    Total keywords: 16644395

    Search > Engine > Index Table selected.
    As per your tutorial: https://documentation.ajaxsearchpro.com/index-table.

    I had Live Search enabled on Enter, but users requested a separate page to link to.
    Now, it hesitates for 5-10 seconds before opening the search page.

    We’re on a decent dedicated server, but we should probably super-size that too.

    Any other ideas?

    #40451
    Ernest Marcinko
    Ernest Marcinko
    Keymaster

    On a dedicated sever I don’t think this should be an issue, our tests were conducted on a single core virtual machine with 1G ram only for 100 000 posts.

    There might be something else at play here. When I try to visit the default results page without triggering ajax search pro override (simply adding “?s=” to the main URL), I am getting a critical error report on the bottom of the page: https://i.imgur.com/MFugMhI.png
    This may indicate something, maybe a memory limit issue in general, or simply a programming error or a bottleneck somewhere. It does not trigger every time, so that may indicate only a memory limit problem. First, try to increase the PHP memory limit a little bit to see if that error disappears permanently.

    After that, if there is no change, the you can add temporary FTP and back-end access, and I will try to debug throught the plugin code to see if I can find anything.
    First, I will programmatically disable the actual search query within ajax search pro, to see if that makes any difference when the results page loads. If not, then the issue is caused by something else, but if it is faster, then I will go through the code line-by-line to see where it’s stuck.

    Best,
    Ernest Marcinko

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


    #40472
    smittelstaedt09
    smittelstaedt09
    Participant

    Thank you very much for your time.
    I will update the DEV clone of our site this weekend so you can check it.

    I don’t see a WP error on the site.
    https://thenewamerican.com/search/?s=

    I’ve turned LiveSearch back on for now until I can improve the search results landing page.

    #40479
    Ernest Marcinko
    Ernest Marcinko
    Keymaster

    Okay, let me know when the update is ready, and I will check on the dev.

    Best,
    Ernest Marcinko

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


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

You must be logged in to reply to this topic.