Delete Mass Records from archive table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
16 hours ago
Hello everyone,
I need a help in deleting 4 million records in a archive table which is ar_sys_email, what is best and safe way to delete these mass records.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
Hey @deekshithkd
I'd recommend making a Destroy rule that aligns with your Archive rules. This can be defined that X amount of time after a record is archived, it should be permanently deleted.
Once you've set this up, it will start running every hour and will slowly but surely get rid of the backlog and then continue deleting newer archived records that meet the threshold 🙂
If this hasn't helped, reply and let me know and we can keep working the problem!
If this has helped, please mark the answer as correct so others with a similar problem can find the answer 🙂