8 Tips for Keeping a Squeaky Clean WordPress Database Useful post by Sarah Gooding at http://wpmu.org/
“Optimizing your database is a necessary part of WordPress housekeeping. Things can start to pile up in there… post revisions, old spam comments, etc., and your blog can start to get sluggish. We’ve gathered a number of solid tips for getting your database into shape without having to be an expert”.
Need to look at the WP-Optimize plugin mentionned.