Database Freespace Compact in a Task
I would like to schedule the Database Compact and Freespace methods as legacy tasks.
Has anyone implemented this yet?
Is this even possible?
The request for this is due to the fact that we have 3 interfaces in a namespace whose messages are deleted after 7 days. All other messages in this namespace should be kept for one year.
This leads to a certain fragmentation. Furthermore, the messages to be deleted are relatively large (MDM^T02 > 32MB), which in turn leads to a fast growth of the database size.
How would you solve this problem?
With kind regards