Disable keys while altering table?

Mr. Goodie2Shoes

Well-known member
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?
 

Mr. Goodie2Shoes

Well-known member
What about the overall execution time? Disabling keys wont be of any help if the overall execution time is more or less the same...
 
Top