Batch size in Update data activity | Community
Skip to main content
szymons55769873
szymons55769873
Level 2
October 13, 2020
Solved

Batch size in Update data activity

  • October 13, 2020
  • 1 reply
  • 2230 views

Hi

 

According to the documentation "Batch size" option translates into:

The Batch size field lets you select the number of inbound transition elements to be updated. For example, if you state 500, the first 500 records dealt with will be updated.

 

Which sounds a bit misleading... It sounds like when I have batch size set to 10 000 and the number of inbound records is 10 100 I will be missing 100 records in the target schema, which sounds ridiculous. 

Could somebody elaborate on this option?

 

Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Darren_Bowers

Hi @szymons55769873 - the Batch Size refers to how many records are processed/committed at the same time in each database call. The default (max) is 10,000 after which it will just iterate to the remainder and then process them as a separate batch call in the activity.

Changing the value can increase or decrease the performance of the database for some operations under certain circumstances

1 reply

Darren_Bowers
Darren_BowersAccepted solution
Level 9
October 13, 2020

Hi @szymons55769873 - the Batch Size refers to how many records are processed/committed at the same time in each database call. The default (max) is 10,000 after which it will just iterate to the remainder and then process them as a separate batch call in the activity.

Changing the value can increase or decrease the performance of the database for some operations under certain circumstances

    Terms & ConditionsAccessibility statement

    Loading footer...