TSP Posted March 20, 2012 Share Posted March 20, 2012 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. Link to comment Share on other sites More sharing options...
bfarber Posted March 21, 2012 Share Posted March 21, 2012 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. Link to comment Share on other sites More sharing options...
TSP Posted March 21, 2012 Author Share Posted March 21, 2012 We found out, thanks! Thanks for bundling up the posts alters as much as you can! ;) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.