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?