...
Unless the customer has legal or business requirements to keep track of what operations has have been performed you can simply delete all entries before a certain date to reduce the file size, as they are not used for anything after they have been processed.
Deleting an entry will delete the XML for that entry, so it will not leave any "orphaned records".If you want to periodically perform this clean up, then you .
You can create a scheduled SQL job queue task to perform the clean up as desired intervals.
Related articles
Filter by label (Content by label)