Custom Sync Provider and Bulk Insert (increasing first load performance) RRS feed

  • Question

  • Hi,

    I am using SyncOrchestrator and two custom providers to synchronize two SQL databases. SQL databases have completely different schemas, so I am using custom providers, derived from KnowledgeSyncProvider. I am using SqlMetadataStore to store metadata, if that is important.

    I want to increase performance of initial load. As my both ends are SQL databases, I could use Bulk Insert to insert data. I could gather all inserts into memory arrays in SaveItemChange method, and do BulkInsert at the end of ProcessChangeBatch method. However, I do not know if that is an appropriate solution. If there are more important details in such solution, an example would be very welcome.

    Donatas Vyzas

    Monday, July 27, 2015 6:42 PM