Every December we delete about 200,000 records from our DB, each record takes about 3 seconds to delete via a vendor supplied deletion tool and the process runs out of hours and at weekends, this is followed up by a dump and reload/reindex on new year's eve run by the vendor.
This process...