How can we help you today? How can we help you today?

Amalgamate ALTER TABLE statements please

I've just downloaded MySQL Compare and tried it on a DB upgrade that we're about to perform. I've got to spend some more time checking to see if anything is missing or different but my first impression is that each table change appears to be in a single statement.

For example one of my tables has 2 columns being removed, 3 added, 2 keys added and one foreign key added. Each of these is listed in the change script as separate ALTER TABLE statement.

This particular table will take around 4 minutes to perform a single ALTER TABLE command meaning the total time would be almost half an hour. If they were joined together into a single statement everything could be done in 4 minutes.
jodrell
0

Comments

1 comment

Sort by
  • Lionel
    Thanks a lot for the feedback. You're correct that those statements should definitely be amalgamated together. Sorry, I didn't read the docs for the alter statement carefully enough so I didn't realise you could do that. I will fix that and hopefully put it in the new EAP.

    Lionel
    Lionel
    0

Add comment

Please sign in to leave a comment.