Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted March 20, 201212 yr 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.
March 21, 201212 yr 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.
March 21, 201212 yr 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.