Hi,
I am wondering if there are any ways I can speed up my database, ever since I had to put in a specific filter to make my view loop work properly, it takes over a minute to load results. I came across this plugin that indexes databases, I am wondering if this is a viable solution that you might recommend, or if there are any other ideas that come to mind? I have a total of 11,000 posts across 3 custom post types, and they are all related and used for the loop.
Here's the Plugin I found: https://wordpress.org/plugins/index-wp-mysql-for-speed/
Thanks,
Sim
Hi Sim,
Thank you for contacting us and I'd be happy to assist.
We haven't officially tested this "Index WP MySQL For Speed" plugin with Toolset, but, practically any optimization plugin that doesn't interfere with the WordPress default query mechanism should work with Toolset plugins.
While we don't recommend any particular optimization plugin, I've seen the "WP Rocket" plugin in use on many Toolset user websites and we also use it on our official Toolset website.
Here is a useful guide on this plugin's prominent features and setup:
hidden link
regards,
Waqar
Since I use SiteGround, I have SG Optimizer and I heard the two plugins don't go well together... any other idea come to mind? Perhaps a way to defer the loading of so many posts at once only until a user actually requests it?
Thanks for writing back and if you're using the SG Optimizer, that is fine too.
Important thing is that website has a specialist optimization plugin, which manages the cache and loading of static resources like CSS and JS files/code for you.
If you're loading all 11,000 posts on the page, without any pagination, then it surely will affect the overall page loading times. In that case, it would be more efficient to load fewer results using pagination when the page loads. And for more results, visitors can cycle through the next pages, as needed.
I am now not able to access the page with my loop results altogether. Would you be able to take a look to see what might be causing it? It just keeps giving me a loading sign over and over again, and the page does not populate.
Sure, I can check what's causing this.
Can you please share temporary admin login details along with the link to this page?
Note: Your next reply will be private and it is recommended to make a complete backup copy, before sharing the access details.
It started working on its own. My issue is resolved now. Thank you!
