Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Schema Synchronization Slow With Large Record Count

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Schema Synchronization Slow With Large Record Count

Tagged: , , ,

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • August 16, 2012 at 5:37 pm #12774
      mford
      Member

      I have several DB's that are to have the same schema. I have 1 as the master. I then do a Schema Synchronization between the Master and DB A or DB B.

      Assuming DB A and DB B require the same exact updates, I have noticed that the Schema Sych may take 90 seconds for DB A, but 2 hours for DB B.

      DB B is significantly larger (more records) than DB A, but how does that explain the huge time difference? Why does comparing schema's get so impacted by the records themselves?

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.