[mysql]UPDATE foo SET bar = ‘bat’ WHERE bag = 1
UPDATE foo SET bar = ‘tab’ WHERE bag = 2
UPDATE foo SET bar = ‘abt’ WHERE bag = 3
...x10000[/mysql]
~20 minutes. And on a busy server, no doubt a plethora of table locks.
[mysql]UPDATE foo SET bar =
CASE
WHEN bag = 1 THEN ‘bat’
WHEN bag = 2 THEN ‘tab’
WHEN bag = 3 THEN ‘abt’
...x10000
END[/mysql]
4.27 seconds.
::tucks away note into hat::
Sixty-six degrees currently, high of 77 later in the afternoon, nice breeze (keeping insect at a minimum), plenty of bird friends, and 802.11n wireless that works flawlessly from over 125 yards away - the perfect office.
Update: I have to share for you to be able to appreciate it.
I don’t know if this is just a problem with Wildblue or with satellite internet service in general, but I’ve come to the conclusion that it just cannot handle SSL connections very well. Slow, slow slow. Sluggish. Like a wet sponge. I’m sure that is why I have problems connecting to the PS3 online store and the Rock Band central server for song downloads. But it affects banking sites, online shopping, reservations, secure web mail, which I originally thought was site-specific connectivity issues, but as the list keeps growing, that is the one common factor: SSL.
I was just declined health insurance from a company whose parent company has been insuring us for the past 6 years. We won’t find out why probably for a few weeks when we get a written statement from them. Makes me wonder though, as described in the somewhat-informative-but-highly-biased movie "Sicko", if we were just declined coverage by an automated system whose job it is to decline a certain percentage of applications and claims because they know most people won’t bother contesting it. Either way, I’m whatever the opposite of thrilled is.
[php]
if ($this->summertime === TRUE)
{
$bass += 2;
$this->alpine->blast = TRUE;
$this->cd->insert();
$this->load->helper('rhyme');
$this->car->cruise = TRUE;
while (TRUE)
{
$this->lay_back();
}
}[/php]
Doctor Jones - My superpower is bending time, and when I need it, the metal sheathing on my neck expands up and covers my face so I'm fully armored. Yes, that kept me up at night. And I bet you thought that "Doctor Jones" was an Indiana Jones reference.
EllisLab Hires New Code Mechanic - After nearly two months searching, we finally found our new Code Mechanic, Justin Hurlburt.
Only a week with my iMac, and I’m spoiled by the silence. I have two very quiet 400GB Seagate external drives, a 250GB LaCie d2, and the new external enclosure for my old 500GB internal Seagate SATA. I can’t stand a single one of them anymore.
With my old G5, I guess the low decibel whirring was relatively silent. The G5’s fans would rev up in anticipation of processing something. It became second nature to me, almost as if driving an exotic sports car; I could anticipate the engine noise associated with various actions. But now, silence. With my G5, externals that had fans were too loud for me. Now even the fanless have a hum that infuriates me. I’m at a loss for words.
I need, absolutely need, an external 500GB so I can continue my SuperDuper! backup cloning schedule of my internal drive. But the new enclosure, the only one with 500GB capacity is the noisiest of them all. So it won’t do. And what am I going to do with the rest, the 1.25TB of cacophonic magnetic media? I even tried sticking the externals in the “CPU cabinet” of my desk, which has a closing front door. No good. Turns the desk into a tuning fork. Solid state cannot arrive soon enough.
CodeIgniter 1.6.2 Released - Latest and greatest version of the fastest, best documented, and easiest to use PHP framework.
My memory arrived. SATA enclosure tomorrow for my old 500GB internal SATA from my G5.
Mmm….candy.
You know you’ve been looking at code too long when you’re reading a forum post on a computer hardware site and read the word "glib" in your head as “gee-libe”. ::sigh::
R2-D2 DVD Projector and Webcam - I bet you didn't realize that a Jedi's lightsaber also served as a handy VoIP phone!
I use a Logitech MX Revolution, which is an absolutely fantastic mouse. The frictionless scroll wheel is reason alone to choose it, but Logitech for some strange reason can’t write an OS X driver to save their lives. Their version for 10.4 and lower used a third party hack to allow programmability of the buttons. For Leopard, Apple tightened up these hacks a bit, so Logitech had to do something, and instead of writing proper drivers, they updated Logitech Control Center to work with their own Input Manager (read: hack) to allow button programmability. This hack causes all sorts of problems, things that you would never attribute to your mouse. Textmate CLI not working, subversion not being able to perform diffs between specific revisions, random crashes, etc.
Since I got my new iMac last week, I decided I would finally give a third party mouse management app a try so I did not have to suffer the corruption that is LCC. Derek Allard and I had a brief discussion about what apps were out there, and it turns out neither of us had tried any of them. Being keyboarders at heart, we’re both multi-button mouse people wanting to maximize the productivity we can have for those moments we have to have one hand on the mouse. He went with USB Overdrive, and I ControllerMate.
I highly recommend ControllerMate, but don’t bother trying it until you have a solid 30 minutes to an hour. It’s interface, resembling more of a UI one might use to modify the skills and attributes of a character in a complex video game, is entirely unlike anything you’ve used before. After you discover how everything is connected, though, the power you are enabled with becomes immediately apparent. I have one combination of mouse buttons that will type a phrase for me, and then position the cursor caret within the phrase where I need to make an adjustment, for a commonly used message I type when moving posts in the ExpressionEngine discussion forum. Wicked cool. Oh, and if my hand’s not on the mouse, I have a keyboard trigger that will do the same thing, using Many Tricks’ Butler app.
Ok, so the nature of my work often makes me feel like I’m multitasking more than any computer could, but let me just say that if I were a fake James Bond villain, I’d share a name with a character from the first Austin Powers: "Random Task". It often seems like I never get more than five minutes with something before another thing jumps in to take precedence.
It’s like conversing with a ten year old girl about her day at school. Branching segues and an hour later you’re finally back to the original story where Sally was trying to copy off of your paper.
The Problem with FaceBook - "A handful of VCs have created the illusion of an actual market by funding apps companies and then doing deals with each other -- passing cash back and forth among to make it look as if money is being made." - Fake Steve Jobs