Monday, August 16, 2004

Molasses in January

I'm no expert on the guts of databases, but as far as I can tell there is no reason on God's green earth that this

insert into soccerstats
select s.id,games.game_id,
s.school_id,s.player_id,s.goals,
s.assists,s.saves,s.timestamp
from soccerstatsold s 
left join games on (
(s.game_id = games.old_id) and 
(games.sport='7' or games.sport='14'))

should be taking over eight minutes to run. It's maddening! Think I need to get a copy of this.

Sunday, August 15, 2004

I've been back for a while, but have been massively busy with work. In case you haven't already gathered, I work for "the Media" -- although I hate that term, because it's often used to imply some sort of massive global information conspiracy, and I personally know that my company couldn't effectively conspire its way out of a paper bag. But I digress.

The point of all this was that my workload tends to fluctuate depending on various cyclical news events -- at the moment, primary elections and high school sports. Plus our company has a management retreat in two weeks so we've got reports to write and powerpoints to slog through. Plus my brother is coming to visit during the same week. And at the moment one person in my department is out sick, and another is on vacation. So, yeah, things have been a bit crazy.

Anyway, in the meantime, I'll leave you with a nifty link to this story in today's paper about this guy who makes pop-art using etch-a-sketches. Very cool. There's only one photo in the article, but here's his actual website.