I finally made a lot of progression
in solving one of the problem
s we have here at work
with a scheduling program
. Normally, a certain action
took about 25 second
s. Since this has to be done hundreds of times every day
, it would save a lot of time if we could speed it up
. Also, the people who are using the program
by it, since they had to wait a while whenever
they were working with that program. So for the past few days
, I've been dig
ging through the source code
s, looking for a way to speed
And I did it. It now takes less
then 3 seconds for that certain action, which
took 25 seconds. I remove
d some redundant piece
s of code
, but that didn't really make a spectacular difference
. Then I found an SQL
which I thought could be a lot
faster, so I rewrote
it. The result
s were far from bad. The procedure
is over 20 seconds faster now.
The rest of the day I've been testing it on the test database, to make sure it really really really works fine. And It does. Now all we have to do is wait for approval to implement it in the production database, which will probably be next Monday.
Around lunchtime, I received a phonecall from a friend of mine. She wanted to tell me a few things. First of all, she now had internet access at home (before that she always used to email me when she was at school), and secondly, she had a new boyfriend. I congratulated her, we chatted a bit more, and before I knew it, it was half an hour later. It reminded me that most women keep talking on the phone about all sorts of things, men don't say more then necessary. I'm somewhat blessed that my girlfriend has a bit of a phobia for phones. However, it would be nice if she called a bit more often.
Besides the above mentioned things, I haven't really done a lot here at work. I've been surfing the web a bit, read most of the new nodes here at E2, and listened to some cds. My music selection here at work for today is the Demons & Wizards album, Tool: Ænima, Krezip: Nothing Less, Blaze: Silicon Messiah, Helloween's new album The Dark Ride, and one the new discs by the Insane Clown Posse: Bizaar (one of the two new discs from their album Bizzar Bizaar).
I can't wait to go home, since I have a light headache, and I still have a few DVD's at home that I haven't watched yet. So I think I'll be watching a movie tonight, and chat a bit on IRC with a few friends and my girlfriend, then go to sleep to rest a bit. I've got a meeting tomorrow, so I have to be awake.