1) Take a database table with over a million rows

2) Add 9 new columns to it with default values and make them all NOT NULL

3) Do this while many users are playing

4) Panic when it takes over 10 minutes to add one column

5) Take down the web server to leave the database migration to run by itself

6) Be embarbumed.

The end!

Good thing the site went back up (relatively) quickly this time! Log in to see images! xXxJUNEGUY1xXx edited this message on 06/17/2008 3:51PM

You need a better database.

Mr 35Tb datawarehouse and 400+Tb of RDBMS under his management

</smug git>

1338h4x Posted:

Do we get all sorts of temporal rift content to make up for it?

Oh, wait, I’m thinking of a different game. Y’know, the one that the developers update now and then.

Yeah, it’s not like we’re working on the largest content update we’ve ever done now.

Or that we’ve added Domination, ForumBuildr, Incit and countless other things since we launched.

Jerk.

But then everyone in your Klan would be banned.

Oh, and it’s a game about trolls. How on God’s green Earth do we keep it jerk-free?

1338h4x Posted:

Do we get all sorts of temporal rift content to make up for it?

Oh, wait, I’m thinking of a different game. Y’know, the one that the developers update now and then.

you mean a bad game with a community which on the far end of the grand internet “spectrum of fabulous personry”?

(the bad far end)

Content update? This sounds exciting…

If the columns have default values why make them not null? Just saying, like.

Lara Croft Posted:

Well, maybe you should stop making boring sub-games.

Just saying.

What’s boring to you isn’t necessarily to someone else. I have heard “xxx is the best aspect of Forumwarz” about all of those “boring” sub-games.

We made the decision after launching Episode 1 that we’d focus on multi-player interactivity before tackling Episode 2. You can breeze through a content update in a matter of weeks, but multi-player games last forever. Looking back, I don’t regret that decision at all.

Sorry if you don’t like it, but you’re getting a content update that will more than double the current content size soon enough.

We can’t be everything to everyone.

inks Posted:

If the columns have default values why make them not null? Just saying, like.

Even with a default value you can specifically insert NULL into it if the column allows NULLS.

Evil Trout Posted:

1) Take a database table with over a million rows

2) Add 9 new columns to it with default values and make them all NOT NULL

3) Do this while many users are playing

4) Panic when it takes over 10 minutes to add one column

5) Take down the web server to leave the database migration to run by itself

6) Be embarbumed.

The end!

We all know this isn’t the real reason you took the server down.