We are using Klevu on our site. Here is their site https://www.headcovers.com/
The search autocomplete runs really fast. See here - https://prnt.sc/qpe7w6 but it's really slow with the Ajax filtering in the category page. See here - https://prnt.sc/qpe8qn
We tested and saw that the filtering process is using MySQL to search which is why it's slow and it causes MySQL to be down sometimes. Does anyone have any suggestions to improve this?
As far as I know, if we use ElasticSearch, everything will be directed to the ElasticSearch server and the search will be very fast so we won't have ever need to worry about MySQL being down. Based on the release note here https://marketplace.magento.com/klevu-module-search.html I think we can use Klevu and ElasticSearch together. Can anyone here confirm that this is the next step for us?
Any help here is much appreciated.
Thank you.