Jump to content

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

Featured Replies

Posted

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.

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.

  • Author

We found out, thanks!

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

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.