Better than this
We've already got a column that represents a binary value. We need to start tracking a new value that is currently one of two values, but may become several. I know! Let's alter the binary column to be an int that will contain codes that map to the cross product of all
--
Drew |
|
|
I guess I'm lucky.
My colleagues are not averse to adding another table or column. They also try to get the type as forward-compatible as is practical. Usually that means a new table plus a lookup. At least because they're not really used to MySQL we get a slightly atypical POV on the problem. Which I approve.
The biggest problem is handling brain-dead decisions made by previous programmers that are a PITA to fix. (Like using a TEXT field instead VARCHAR. And the table is 19 million rows. And ALTER TABLE on that in MySQL takes hours. We can't have the site down that long...) Just don't get me started on JDBC rules. (Sometimes I hate Java nulls.) Wade. Static Scribblings http://staticsan.blogspot.com/
|
Database Question.
- (mmoffitt)
- (11)
- Nov. 18, 2011, 02:06:51 PM EST
Wow... that was deviant!
- (folkert)
- (8)
- Nov. 18, 2011, 02:19:44 PM EST
Heh.
- (mmoffitt)
- (7)
- Nov. 18, 2011, 03:03:15 PM EST
*Boggle* is entirely appropriate.
- (static)
- (6)
- Nov. 18, 2011, 06:48:24 PM EST
Better than this
- (drook)
- (1)
- Nov. 18, 2011, 10:39:31 PM EST
I guess I'm lucky.
- (static)
- Nov. 19, 2011, 06:26:45 AM EST
I agree on the 200.
- (mmoffitt)
- (3)
- Nov. 19, 2011, 09:45:21 AM EST
What is your update schedule? And will you be coding in it?
- (crazy)
- (2)
- Nov. 19, 2011, 11:19:23 AM EST
Nope. Happily I will not be directly involved in any of it.
- (mmoffitt)
- (1)
- Nov. 21, 2011, 01:40:13 PM EST
Smart move
-NT
- (crazy)
- Nov. 21, 2011, 05:21:52 PM EST
OLTP? Not a data warehouse?
-NT
- (S1mon_Jester)
- (1)
- Nov. 19, 2011, 07:18:23 PM EST
Re: OLTP? Not a data warehouse?
- (mmoffitt)
- Nov. 21, 2011, 01:42:43 PM EST
