15. října 2009 14:28Can anybody point me to a good example of using batching with multiple tables as all of the examples I have found so far only include a single table and I cannot see how this can be applied across multiples.
I have about 20 tables in a solution that I am building, most of which are download only, but all of which can have quite significant throughput of changes between synchronisations. I would like to implement batching in order to speed up the downloads (as this is what everybody says batching will acheive).
I am using SQL2005 and SQL/CE on a mobile device.
19. října 2009 21:24Přispěvatel
Batching properties are set on a per synchronization basis - so it would not make a difference as to how many tables are being synced in one session. Just set the MemoryDataCacheSize to what is an appropriate value for you.
Deepa ( Microsoft Sync Framework)
21. října 2009 15:45Thank you for your answer, but I suspect you may be referring to v2.0 here; what I forgot to mention originally was that the application concerned is (currently) using v1.0 - though this may change depending on the answer to another question I am about to ask regarding compatibility between v1.0 for devices and v2.0.