Database woes
Aug. 5th, 2008 07:33 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
A few years ago, I designed a database for Monique to use for calculating monthly savings for her COB department. It does some pretty complex stuff behind the scenes, but the user interface is pretty easy. You put in a start and end date for the month you want, you press a button and presto, results (after about 45 minutes of processing). Since then, she's moved up in the world and given this to her minions to work on.
I've spent more time on this database off and on since then doing enhancements. Lately, they have some problem running it every single month and I find myself in here (United Health) at night after my real job running the darned thing for them. I don't get it. They have explicit directions. It runs fine when I run it. I'm getting sick and tired of coming in here and fixing the darned thing. This is four months in a row and it's different every month.
Ok, I'm done venting now. Move along. Nothing to see here. Next month it will be perfect (he says optimistically).
I've spent more time on this database off and on since then doing enhancements. Lately, they have some problem running it every single month and I find myself in here (United Health) at night after my real job running the darned thing for them. I don't get it. They have explicit directions. It runs fine when I run it. I'm getting sick and tired of coming in here and fixing the darned thing. This is four months in a row and it's different every month.
Ok, I'm done venting now. Move along. Nothing to see here. Next month it will be perfect (he says optimistically).