• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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?