Setting the Batch Size with SF_TableLoader
Setting the Batch Size with SF_TableLoader
SF_TableLoader
with the soap switch uses a default batch size of 200 rows
(SOAP API). When using the bulkapi, it uses a default batch size of
10,000. If you need to reduce the batch size, use batchsize(𝘹𝘹)
.
For example, to set the batch size to 50:
EXEC SF_TableLoader 'Update:soap,batchsize(50)','Salesforce','User_Upd'
EXEC SF_TableLoader 'Update:batchsize(50)','Salesforce','User_Upd'
NOTE: The batchsize option is ignored if SF_TableLoader
uses BulkAPI2.