Once a week is fine for most sites. If you have a larger website or constantly install/delete plugins, you can clean your database more frequently.