TechPedia

Over on BabyGotMac, I was suffering with a SLOW load time. Looking into the issues, I noticed that my Wordpress wp_options database was a whopping 23mb. I started looking for the offending entries, and found that a plugin I had installed a long while back had added some 500 rows that contained the phrase ‘magpie rss’.

After determining that I no longer needed the rows, I uses phpmyadmin and removed them. I recovered over 12mb of database and the site now loads considerably faster.

The moral of the story: keep an eye on the database and let plugin authors know they should not put their options into the primary wp_options db, so when/if you need to remove them, you can easily dump the db entries too - and plugin authors: offer your users the option to remove your tables before they deactivate your plugin!