Entries this day: AM Work lovely_lovely_Ami xkcd

AM

7:44am JST Tuesday 20 November 2007 (day 13754)

Last night I did not get onto my computer after arriving home. I basically ate, flossed, brushed, meditated, went straight to bed, all the while (except during brushing and meditation) reading A Walk in the Woods. I laughed at "Yew boys wunna rod?" and something else, but I don't recall what.

Woke up without my alarm this morning at 6:50; went down to shower, took out the trash (we had a bit of an accumulation (since we would sometimes get lazy and not take out the one bag, 鈴木さん got us another trash bin, and so we're able to be that much lazier) as both bins were full on Saturday night, so Juergen tied them off and set them by the kitchen door where they waited until now) because we can only take it out on Tuesday, Thursday, and Saturday mornings (between 7am and 8:30).

7:58am JST

I seem to be stuck on my computer as I write this; I've got to get up to get down to some food and work.

Work

8:44pm JST Tuesday 20 November 2007 (day 13754)

Good day at work today. Arguably the best so far. I learned a good bit about how our system is set up, and a great technique for optimizing mySQL queries.

I almost wrote a message to php.general on usenet:

HI All

I have been asked to optimize a query here at work, and suffice to say the query is big and ugly.
SELECT (SELECT * on JOIN z JOIN B JOIN (SELECT * on w JOIN x JOIN y JOIN z) as wxyz) as z JOIN JOIN
JOIN..  that kinda thing.

There are indexes on all the columns that are part of the JOIN clauses.  I ran an EXPLAIN and got this:



Pretty quickly I see 22000 * 22000 = too many rows with no index!!

I found a suggestion to make a temporary table and put an index on that:
http://forums.mysql.com/read.php?115,104645,104645

However, I ...


oh.  Nevamind.

I was going to say "However, I keep getting an error," when I realized I didn't know what the error message was.

Turned out that the error was something trivial like "permission denied," and once I fixed that, it turned out that my technique was perfectly ready to work. Woohoo!

Once I got all the details sorted, I had reduced the search time from between 60 to 90+ seconds (90 is timeout) to between 6 and 20 seconds. Whoo to the Hoo. That rulesez. I *think* I should be able to get it down even more now that I have a sense of what technique I can use to optimize.

lovely lovely Ami

12:25am JST Wednesday 21 November 2007 (day 13755)

Best time ever with Ami tonight. She came over and we just cuddled in bed and somehow restrained ourselves from monkey business.

Hilarious things:

1. her technique of giving me medicine, as I was resisting it like a dog. She gave me kisses and then jammed the capsules down into my mouth, poured soy milk down to make it all go.

2. blowing games and giving her booty tickle-induced goosebumps.

3. While I was trying to undress her, Ami: "I gotta go; wait until tomorrow."

   Me: "it's already tomorrow."

   Her: "no it's not.."

   Me: "oh, then we have time!"

4. Me chasing after her like a puppy after she started home on her bicycle. Ami, "[go] home!" so I went back, and then chased after her as soon as she started away.

xkcd

Okay, this is it; I've gone through the whole series so far and posted all my favorites, including these two: