Probably better to use partitioned table and drop old partitions.