Hi,
I have some issues with my site. It loads extremely slow and have some problem with the data base.
I have installed WP super cache, but after the issues start I installed Autoptimize also and made some changes in .htaccess file for gzip compresion and leverage browser caching. I also stop wp-cron job and activate cPanel cron job for the site.
Unfortunately that didn’t help and my site is still slow if load, because sometimes it do not load and give Error in database connection or 500 internal server error…
I contacted my VPS provider and they answered me that it is theme issue.
The theme is written in a way that each time somebody visit the site to perform the calculation of posts due to pagination on the site. The exact MySQL query is:
//
SELECT SQL_CALC_FOUND_ROWS wpvr_posts.ID FROM wpvr_posts INNER JOIN wpvr_postmeta ON ( wpvr_posts.
//
And said that this calculation every time overloading the server.
I thought that it is because I have thousand of posts and on the home page is loading “Recent post” with pagination and that way I have changed Hime page to default template and now I haven’t pagination on home page, but the problem is still exist…
Would you have any idea what is the problem and how to resolve it?
My site is: http://petrichnews.info/
Thank you in advance for your time and assistance!
All the best,
Ivan
Hello Ivan,
First let’s start by removing autoptimize. That makes things worse. Please remove any customization you made and revert the theme. Please disable all plugins except the tested and recommended ones: https://www.screencast.com/t/VOeWxr4li6Y
Please make sure you increase the system status parameters like so: https://forum.tagdiv.com/system-status-parameters-guide/
The use this guide to increase your site speed: https://forum.tagdiv.com/how-to-make-the-site-faster/
Make sure you use a caching plugin like so: https://forum.tagdiv.com/cache-plugin-install-and-configure/
Thank you!
