I've got a civicrm database of 1.4 Go (information available in PhpMyAdmin) 1Go is used by civicrm_activity table I would like to know if have to clean, purge the database to reduce its size, cache or others maintenance actions.
I find some actions on documentation for cache files but nothing about database
Thanks for advices
civicrm_activity is a legitimate table with legitimate data. You can use the API to mass-delete activities - but only you (and/or your users) can determine what represents data that is reasonable to delete.
If it's that large, I suspect it's quite likely that you're sending frequent mailings to large groups of people - the mailing history might be reasonable thing to delete.
