Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Schema Synchronization Slow With Large Record Count
Tagged: Compare, schema, speed, Synchronization
This topic contains 0 replies, has 0 voices, and was last updated by mford 6 years, 11 months ago.
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.