Hi cjam,
Best would be to review your code and see if there are many queries in your theme. Try also reducing the amount of widgets that show related posts, most commented posts, most recent posts, etc. It seems like there are several queries on your front page alone; see if you can reduce these or just do one big query and separate the information.
Another good solution is to install a cache plugin, such as W3 Total Cache or WP Super Cache (only install one, as multiple caching plugins can generate errors).
If this helps you, please let us know and mark this post as “Solved”.
Cheers.
Thread Starter
cjam
(@cjam)
Thanks for the reply. Yikes, reduce the widgets? I’ve already tried to keep it at the lowest # possible of active widgets. I don’t think I can break it down anymore. Do they use queries if they aren’t activated? I have to tell you I’m not too familiar on how to make one big query.
Do those cache plugins do the same as optimizing the database. This is all a little confusing and I’m really nervous some of my content will be lost.
Hi cjam,
If the widgets aren’t active, they shouldn’t pose a threat.
But just by installing W3 Total Cache you have an option to optimize the database. This *should* do the trick. Try installing it and looking for the “Optimize database” option and select to to “Basic”. After, disable the preview mode for the caching to be activated.
I do recommend you install the “WP DB Backup” plugin before and make a backup of your database, just in case. It is highly unlikely that you will lose any content (I mean, really near impossible) but you never can be too cautious, right?
Making one big query and selecting which post goes where can be quite complicated; if all else fails, try hiring someone with the expertise to do so.
If you have any other questions, please let us know.
Cheers.
