We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Delete Mass Records from archive table

deekshithkd
Tera Contributor

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.

1 REPLY 1

Kieran3
Tera Expert

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 🙂