derek derek derek

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

~20 minutes.  And on a busy server, no doubt a plethora of table locks.

UPDATE foo SET bar =
	CASE
		WHEN bag = 1 THEN 'bat'
		WHEN bag = 2 THEN 'tab'
		WHEN bag = 3 THEN 'abt'
		...x10000
	END

4.27 seconds.

::tucks away note into hat::