Disable keys while altering table?

Mr. Goodie2Shoes

Well-known member
#1
Altering a table, lets say xf_post, with millions of rows might take some time. And disabling keys before the alter reduces the execution time.

Though I haven't tested it as I don't have such board to test on :p Do any of you have any experience with this? Does it have any side effect?
 
Top