How to improve the speed during first time sync with large table RRS feed

  • Question

  • Hi, 

    i'm new to syncframework, and by using some sample on the msdn, i managed to create 1 application that can sync over the internet, the purpose is to sync some of the data from different side back to our office. 

    but i facing 1 problem, since before the program is develop, each site already have some data, might be more than 100K of row for certain table. 

    so, when i run the sync data. it took very very long time during especially those table with large record. but i know that, once the first sync is done, the subsequent is fast, since they only take the changes/newly added/modify one. 

    can anyone let me know, how can i improve the speed during first sync when dealing with large table? any method that i can skip and avoid the first sync took long time. 

    p/s: the first sync is done over internet. since our HQ and side are quite far. 

    thanks and regards



    Wednesday, April 6, 2011 8:39 AM