1. 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?

Discussion in 'XenForo Development Discussions' started by Mr. Goodie2Shoes, Dec 31, 2014.

  1. Mr. Goodie2Shoes

    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?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

  3. Mr. Goodie2Shoes

    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...
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    You would have to do some testing to check.
     

Share This Page