- This topic has 4 replies, 2 voices, and was last updated 1 week, 4 days ago by
.
-
Posts
-
After we do a server migration and enable cloudflare enterprise, we noticed that the Ajax Search Pro get very, very slow, we recreate the index table, and we clean the ajax search pro, but still very slow.
Hi Boris,
Thank you very much for the details, it helps a lot.
There seems to be a general issue somewhere on the website. When I try to load the products page, it takes ~8 seconds to load, if I enter a search term on the products page on the back-end, then it’s over 30 seconds, so it looks like something might be adding a lot of workload to the server. I suspect that there might be a little too many plugins active and one or more is causing a massive workload for certain tasks. I strongly recommend removing some plugins which you may not use, it can significantly improve the overall site health. If you are using cloudflare enterprise, then I would disable all cache, query monitor and profiler plugins, those are already mitigated by Cloudflare itself.
The index is small, it’s only 10000 keywords, it should execute almost instantly. I did a debugging and found one issue, and that was the primary ordering using the stock status, but that shouldn’t be an issue at all. I changed it to relevance, now some bottleneck is gone and the search is a lot faster. I recommend checking the wp_postmeta table, perhaps do a degfragmentation on it, it seems like something might be wrong there, as all queries on the metadata table seem to be slowed down for some reason, maybe there is a table lock or a paging issue that could be solved via an optimize table commad. I also strongly recommend trying this plugin after you did a table optimize command on the postmeta table.
thk for the help, is working better now, and we continue checking the performance of the site, SOMETHING IMPORTANT, I use the stock status to put at the last products without stock, for example for the keywoord “pre entreno” now the first product that display is Unlock, and right now is out of stock, so is the best to move it to the end of the search results (dont hide, only move to the last), so can you help us to achieve that?
The main issue with that is, that something is extremely clogging up the wp_postmeta table in your database. If I re-enable the stock status ordering it will re-trigger the slowdown.
Have you checked the wp_postmeta table state? Have you tried adding indexes via the index sql plugin?
I suspect there might be a serious fragmentation problem with that table, or it has grown way too big, I strongly recommend checking it, otherwise if I make the change it will get slow because of the very slow response from that table.
- You must be logged in to reply to this topic.