Repetitive task is repetitive

2009/01/22

We have a database that stores all the little details about how utilized our network is.  It has information at 5 minute averages, 1 hour averages, and 1 day averages.  The software that does this is supposed to keep only 3 months worth of 5 minute data, 6 months worth of hourly, and a year worth of daily.  You’d think that since the feature shipped with the initial product that by version 5 it would work.  

 

It doesn’t.

So here I sit going through table by table looking at the definition of the table, finding what the timestamp column is named and telling the table to delete everything more recent than a certain second.  This task is not hard, this task is boring though.  Someone email me some sudoku’s.