Why synchronization speed is slow?
There are many factors that have an influence on synchronization speed. The most important is an availability of primary keys in synchronizing table, another one is a number of fields and records and the last critical issue that can slow down the speed is a data type. “Update” synchronization works by comparing record-by-record. And if your record contains, let us assume, 5 empty fields, of course, it will be processed much faster than if your records has binary data. “Insert” and/or “Drop” synchronization options compare Primary Keys’ set but not each record. In this situation, we can recommend one of the following solutions: • Create filters for urgent synching and for example for “night” synching. • Find the tables that require more time for synching and separate their synching in another session. • Please check if you have Primary key structure in your tables. If don’t, assign it. Notice, that you can check Pkeys on Customization stage. • Before scheduling please check workability
