Hey there,
I have a relatively large installation of wordpress where I have over 200k posts.
The SQL_CALC_FOUND_ROWS results in slow page loads and is called multiple times on every page.
Is it possible to avoid the use of it somehow? I don’t think that I would need it on my elements where I showcase specific categories, I can use a load more button or something like this but it still calls SQL_CALC_FOUND_ROWS query.
Is it possible to set the SQL_CALC_FOUND_ROWS to (‘no_found_rows’,true) and skip this 1-1.5 sec delay?
Please help and answer my question, I don’t need any ideas on speeding the site, it has caching, it has everything needed, it is more than powerful – the problem is that this query is slowing things down (my DB is fast, it is on SSD and indexed properly).
Hello!
This issue has been discussed already here, please check: https://forum.tagdiv.com/topic/search-results-is-slow-in-returning-results/
Thank you!
I read this and this doesn’t resolve the issue. As stated in my post, I have done everything mentioned except “Reduce your blocks” which isn’t what I am looking for. Can any developer look into this and get in touch with me?
Hello!
Sure. Please contact us via email.
Thank you!
What email?
Hello!
Please contact us via email at contact@tagdiv.com and provide the following:
– admin URL and credentials
– cPanel URL and credentials
– a link to this topic in order to identify you
Thank you!
