In the procedure they are deleting values before a particular date.

Values are deleted from a master table and inserting into a another table.

Smaller chunks in the sense changing the date value to a shorter period will help??