Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › Search results
This topic contains 1 reply, has 2 voices, and was last updated by Ernest Marcinko 6 years, 7 months ago.
- AuthorPosts
- August 10, 2017 at 12:18 pm #14208
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.August 10, 2017 at 1:18 pm #14210Hi,
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.pngThese 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:
Best,
– Index table engine
– Search performance and Improving search performance
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)
- AuthorPosts
You must be logged in to reply to this topic.