Hello,
my postmeta table reach 50k row, the total size of the database alone is 200mb.. this bit worry me if there some optimization that i need to be done.
Anybody like to share optimization tips ?
Well, I use wp-optimize plugin to clean house.
You can also periodically check for errors and cleanup with PHPmyAdmin from your hosting panel. You can inspect tables and if you no longer use, or ever plan to use, an old plugin which added tables, you can scrub those very carefully following various tutorials online.
My main site dbase is 252MB, with 14,000 posts. 🙂
1) deactivate and uninstall all plugins you arnt using.
2) install Plugins Garbage Collector, activate an run it.(https://es-mx.wordpress.org/plugins/plugins-garbage-collector/)
3) clear all garbage tables whit garbage collector
4) deactivate garbage collector and install WP Speep to clean up and optimize DB (https://es-mx.wordpress.org/plugins/wp-sweep/)
5) Sweep your db 😛
Thats all, your db its fully optimized now
