Batching example with multiple related tables

Question

Can 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.

Thanks.

Answer 1

Hi -

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.

Thanks
Deepa

---

Deepa ( Microsoft Sync Framework)

Answer 2

Thank 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.