3.3 upgrade: shouldn't the alters be combined into one query?

[TSP]

Hi, we see there's three different alter queries to be run on the posts-table when upgrading to 3.3. Shouldn't they've been combined into one queries? With 19 million rows for us to pass through that seems much more efficient.

We will run the queries manually and change them to be one query ourselves, but just thought I could throw in our thoughts on it.

[bfarber]

They are only run in a very specific circumstance (namely, you installed IPB after 3.2.0 was released, because the queries were included in the 3.2.0 upgrader), in which case it shouldn't matter - not too many sites could have grown a huge posts table in that short a time period. As I recall, they were split up so that we could validate each column individually to make sure it was present.

In your case, you don't have to run them.

[TSP]

We found out, thanks!

Thanks for bundling up the posts alters as much as you can! ;)