Oracle HFM? Make sure db statistics are set to update regularly. Two years worth of data can add up quickly, and the db needs to know when a table goes over 500k rows.