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

  • This topic is empty.
Viewing 0 reply threads
  • Author
    • #12774

      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?

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