Well, that felt good

At work, we had an operation that was taking too damn long. Looked at the code, looked at the query it was generating, and it was pretty horrible, but I don’t see any way to avoid doing it. Then used the SQL “explain” on the query. Hmmm, it’s doing a sequential scan on two different tables. Hmm… Put an index on one column on one of the tables. Suddenly it’s only doing a lookup on one table. Ran downstairs to the big 30-plex test machine. Did the test once. Took 1:31. Added the index. Ran the test again. Took 0:08.

I’m a fucking genius.

MovableType

This web log software I’m using, MovableType appears to be extremely functional and customizable. One thing I’m thinking of doing is converting the “what’s new” portions of my CoPilot and my Rochester Flying Club web sites into blogs. Either the static content could be put in in the template, or maybe the blog portion could be embedded as a frame or an iframe. I’m obviously going to have to experiment some with this.

Another thing I’d like to do is learn a whole bunch more about style sheets, since I’ve seen some amazing stuff done with them.