Batchsize Calculation. RRS feed

  • Question

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


    Friday, November 16, 2012 4:20 AM


  • 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