Make it very clear when new versions have large schema updates
|Reported by:||matt||Owned by:|
We had issues in the past (in 0.5) when we released large schema upgrade causing time outs on some hosts, and we had to offer a lot of support in the forums.
I would like to propose a few steps to make this better in future releases (0.5.5 looks like it might contain such massive schema upgrade)
1) Improve the messaging in the welcome update page and display a big red warning message when a large schema update will happen. This is the case whenever a large table (log_ or archive_) have new fields, new INDEXes, or various other bulk updates. We could have a flag/method in the update class that would be set to true when the update can potentially lead to such issues.
2) We should also display the list of SQL queries that are going to be executed so that the user can execute them manually in case of error.
3) Since 0.5 there is a feature that updates can be ran using the safer command line upgrade mechanism. This should also be highlighted.