Forum Post Install Task - upgrade_400a1_indexes.php
 

Hi,

I noticed that it says:
Quote:
vBulletin 4.0 Post Upgrade Because of the size of your post table, new post and thread indexes were not added during the upgrade because this could take considerable time. Instead, a script has been provided to add these indexes seperately at /install/upgrade_400a1_indexes.php. Instructions for how to use the script can be found in that file.
While these indexes are not required to operate vBulletin, they should improve performance for large boards. Adding them is highly recommended.


Just wondering what the purpose of this script is exactly (Done a search but didn't come up with anything). Also how server resource intensive is it to run on a board with 1.5Million posts?

Just would like to know a bit more about it before I run it. Thanks!

FYI: Recently upgraded from 3.8.4 to 4.0.1 PL4