Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Batch size in Update data activity

Avatar

Avatar
Ignite 1
Level 2
szymons55769873
Level 2

Likes

5 likes

Total Posts

22 posts

Correct Reply

0 solutions
Top badges earned
Ignite 1
Validate 1
Give Back
Boost 5
Boost 3
View profile

Avatar
Ignite 1
Level 2
szymons55769873
Level 2

Likes

5 likes

Total Posts

22 posts

Correct Reply

0 solutions
Top badges earned
Ignite 1
Validate 1
Give Back
Boost 5
Boost 3
View profile
szymons55769873
Level 2

12-10-2020

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

77 likes

Total Posts

253 posts

Correct Reply

82 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile

Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

77 likes

Total Posts

253 posts

Correct Reply

82 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
MVP

12-10-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

Answers (0)