inks Posted:

And the problem is?

I can’t remember what database you’re using and of course I’m an amateur expert but I don’t think it adds anything to not null a column unless you’re indexing it. And the only reason to index an additional nine columns would be if they’re foreign keys I’d have thought, which is possible of course.

Ho hmmm anyway the database coped all is well!

The new columns weren’t indexed, that’s true. I think it’s more like it had to go through all 1.2M records 9 times. Adding each one seemed to take about 2 minutes at first, but then people started fighting for write access to the table (because I was doing it live) and the whole thing barfed.

Still, 15-20 minutes of downtime total isn’t bad.