Advanced sync setup: Difference between revisions

Jump to navigation Jump to search
Line 318: Line 318:


This flag is primarily meant for Dynamics (Salesforce does not use versionnumbers).  
This flag is primarily meant for Dynamics (Salesforce does not use versionnumbers).  
Microsoft recommends using versionnumber sorting as it greatly improves the performance of some fetches. However, our tests show that in some cases, it has the opposite effect. Setting on/off this flag can change fetch performance from minutes to a fraction of a second - or vice versa. The reason apparently lies in the SQL server setup (definition of indexes, etc.) and cannot be predicted. Use this flag as the last resort if you have an extremely slow fetch in incremental sync. It may, but also may not help.
Versionnumber sorting is generally discouraged as it may negatively affect the performances of most fetches. In some cases, it has the opposite effect. Setting on/off this flag can change fetch performance from minutes to a fraction of a second - or vice versa. The reason apparently lies in the SQL server setup (definition of indexes, etc.) and cannot be predicted. Use this flag as the last resort if you have an extremely slow fetch in incremental sync. It may, but also may not help.


== Custom upload order ==
== Custom upload order ==

Navigation menu