Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Batchsize Calculation. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi.

    right now I am assigning batchsize to a fixed number (ex: provider.memorydatacachesize=1024)

    is there any formula I can use to calculate the batchsize based on worth of changes (MB) before the sync session starts.

    thnk you.

    ess

    Friday, November 16, 2012 4:20 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    depending on the amount of changes that you have, querying the database just to get an idea how much changes are there may be an expensive operation.

    i normally base the batch size on average row size... if i have rows that are around 1k each, then a 1024 batch would more or less mean 10 rows per batch. if i have 100 row changes on average, i know it would take at least 10 batches...

    • Marked as answer by saitrips Friday, November 16, 2012 7:19 PM
    Friday, November 16, 2012 5:19 AM