What happens when you try to fit 4 hours worth of work into a 3 hour window?
Timeouts!
Peeps be complaining about timeout errors, and my investigation turned up that a database table had 20 million rows in it. It shouldn't have that many. Apparently nobody thought to delete old records after they've served their purpose. Untill now. Table size down to 3 million rows, program runs in 1h 30m, and timeouts vanish.
Let this be a lesson to all those storing data.
Peeps be complaining about timeout errors, and my investigation turned up that a database table had 20 million rows in it. It shouldn't have that many. Apparently nobody thought to delete old records after they've served their purpose. Untill now. Table size down to 3 million rows, program runs in 1h 30m, and timeouts vanish.
Let this be a lesson to all those storing data.