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 contains 0 replies, has 0 voices, and was last updated by  mford 6 years, 11 months ago.

  • Author
    Posts
  • #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?

You must be logged in to reply to this topic.