Also if you are constantly deleting rows based on date you might consider partitioning the table by date. For example if you 1 year of data, you can either partition by month or quarter and then drop the oldest partitions.

But triggers can definitely be an issue, especially when the are trying to do too much.