We are in a situation where there are over 1 million! messages in the mail_message table. They are almost all type = 'notification'. I think this is because we are running our MRP scheduler every minute. I plan to change that setting but I want to know if it's safe to delete these messages? Would there be any ill effects? Should I delete from the web interface or would it be safe to delete directly form the database table?
The database has grown faster than I anticipated. We've only been online for a couple months and I'd like to clean things up.
Thanks!