To be honest I've never tried this before, even though my forums have been running for a few years now.
- How often should the database be optimized?
- What is the best way to do this (command line perhaps?)?
- Is there any risk involved, could the database become corrupted as a result of this operation?