My in-laws had their car broken into last night. Four years in this town, and in the last month here my guests get victimized. They had their car parked in the hotel parking lot (out front of the building) directly under a light. The thieves destroyed the driver side back-door window with a rock, cleaned up the shards around the edges, and crawled in through the still locked and closed door. Apparently, if you do it this way, it fails to trigger the car alarm. Fortunately, the thieves were dumbasses, and got away with a bag filled with books-on-CD and an old model digital camera. They totally ignored some other juicy pieces of consumer electronics that were under the seat. The only lesson I’m getting here is “don’t leave anything that might appear to be of value (CDs) visible in your car.” Oh yeah, and also “you people can’t have nice things, you just break them.”
The rest of the day was spent moving a database bottleneck around. When I started the day, I was blocking at the network between the cluster nodes and the DB. I combined the SELECT and INSERT queries into one big query, and moved the bottleneck inside the DB. At that point it was blocking as each of these mighty queries locked the entire table for the duration of their work…leaving the rest of the queries to hang in the wind. I enabled row-level locking instead of table-level, and now we’re experiencing some new sort of pain. Each of these improvements has resulted in ZERO speedup…though I keep feeling that if I just plug at it a little bit more, we’ll break the dam and slam through to high-speed updates.