This website uses cookies to personalize your experience. By using this website you agree to our cookie policy.

Slow autocompletion

Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › Slow autocompletion

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • March 30, 2023 at 9:17 am #42029
    AllanAllan
    Participant

    Hi,
    I have a problem with slow response time of admin-ajax.php for displaying autocomplete.

    I’m having trouble knowing if the an Ajax Search Pro specific issue or not.
    A quick test idea?
    Either way, this seems to be related to the server configuration, as I don’t have this issue on my local development build.
    However, I don’t see anything that seems blocking on this server.

    In the meantime, I have enabled indexing through the database.

    I am waiting to know if I have the agreement to give you access to a pre-production version of the website. In the meantime, I will send you the server configuration.

    March 30, 2023 at 1:42 pm #42037
    Ernest MarcinkoErnest Marcinko
    Keymaster

    Hi,

    Thank you for the details, it helps a lot! The configuration seems to be perfectly fine to me.

    I tried on the given URL, but it seems to be more than fine, actually super fast on my end – responses around 400ms and less, that is very impressive: https://i.imgur.com/UHskrhG.png
    I tested a few more phrases but it never went above 600ms.

    Does this happen for specific phrases or is this already resolved? If the requests are delayed only on your end, then I would recommend checking your firewall as well as browser extensions. Some browser extensions can temper with the requests and delay the execution.

    March 30, 2023 at 2:01 pm #42042
    AllanAllan
    Participant

    Hi,

    Sorry, I didn’t have time to send a message back.

    As indicated, I activated the indexing cache: Caching Options > Caching activated + Caching method > Database

    In the meantime, I realized that I also had to change the option: Search source > Post Type Search > Search engine > Index table engine

    And since indeed, it is very fast, but I do not know if it is a good use or an element which makes it possible to identify the source of the problem in the event of use of the regular engine.

    March 30, 2023 at 2:18 pm #42046
    Ernest MarcinkoErnest Marcinko
    Keymaster

    If you have a lot of posts (or very lenghty post contents), then it was definitely the regular engine. Generally the WordPress database does not like search queries on the posts table, and if it’s a bit bigger then it may take some time.

    March 30, 2023 at 2:26 pm #42048
    AllanAllan
    Participant

    I’ve 436 items indexed, some with long content.

    March 30, 2023 at 2:28 pm #42049
    Ernest MarcinkoErnest Marcinko
    Keymaster

    That’s not a lot, but could be it – especially that WP stores a lot of drafts and revisions, which adds up quickly.

    March 30, 2023 at 2:34 pm #42050
    AllanAllan
    Participant

    If you think it’s okay to use the index table engine with the database, you can close this ticket.
    I have setup cron update every hour.

    Thank you for your answers.

    March 30, 2023 at 2:36 pm #42052
    Ernest MarcinkoErnest Marcinko
    Keymaster

    You cannot access this content.

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)
  • The topic ‘Slow autocompletion’ is closed to new replies.