Optimize your Wordpress database

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 …