Please create a dedicated tutorial on optimizing a WooCommerce site database. It should cover not just installing a plugin, but also complete advanced database optimization, proper caching installation, and more. Thanks!
Thanks for the tutorial - turns out, my options table is 14mb big on my simple tiny blog. Trying to figure out why the heck astra has so many large files, and whether it's linked to anything so I can delete them.
I have an idea for a new video, although I don't know how many people it would help: I was just looking through my database and notice that I have what appear to be duplicate tables with different prefixes. I think what happened was that I changed the database prefix using a security plugin, then later deleted the plugin which I think changed the prefix back to wp_ In any event, I just looked in my wp config file and the current prefix is indeed wp_ When the prefix gets changed by a security plugin, does the system duplicate all the existing tables with the new prefix? If that’s the case, can I drop all the other tables that have the prefix which is not in use?
Never heard of a security plugin doing that. I have seen that when multiple WordPress installs have used the same database, with different prefixes. Either way, yeah... deleting the tables which are not in use now shouldn't give any issue. Might want to back up first, just in case. ;)
@@BlogMarketingAcademy I determined what the problem was. The different prefix'd tables in my database were the result of a staging site that didn't get properly deleted by the plugin that created it (WP Time Capsule)
