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 …

And we’re back…

Although BabyGotMac is doing well, the need to have somewhere to post non-Mac stuff is overwhelming, so TechPedia is back.

The DB backups seem to be missing about 6 months of posts, but I’ll try to get it current and start posting more content here, including Wordpress and Pligg (which is being used on MacLoot.com) tips.

Feel free to send me tips, articles or links.

Yours,
Scott