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.
I’m still working on the flying club web machine. I’ve put together a main page for them to look at. Basically I think the machine is functional as it is, but I want more.
Continue reading “Still working on it”
I’m setting up a computer for the flying club’s ops room. Basically I want this to be a “web kiosk”, as idiot proof as possible, because let’s face it, when it comes to computers, some pilots are complete idiots.
Continue reading “Getting this thing to work”
So I’ve had this blog for what, 3 days now? And already somebody posted a penis spam in the comments. So I had to remove the comment and ban the IP, which is a royal pain. All spammers must die. Painfully.
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.