I’ve noticed if people use Ajax search box, there is a delay and CPU spike as the search goes on. Is there any information on how to optimize the MySQL query or use object cache with memcached to optimize the search so it’s fast & snappy?
Hi,
Unfortunately, please notice that our recommended caching plugin is WP Super Cache which might be set up according to our documentation from here -> https://forum.tagdiv.com/cache-plugin-install-and-configure/ Notice that we do not provide any optimization services and also, we do not receive any bad report until now, sorry!
Thanks for your understanding!
I already cache php content with Nginx fastcgi cache. I just noticed if you run top on my box and do a search, you can see sql consumes all the cpu for a brief delay and everything comes back. It’s not that the search is terribly slow, but i would love to pre-cache it so the response is faster and there is less load on my server. Is there a sql query its running that i could make sure to optimize around? guess i’ll enable query tracing and see myself, but figured i would ask. The behavior doesn’t look unique to my site and most people may not be paying close attention to search 🙂
