17.20Why not For Each?
Because:
500,000 records
×
one Salesforce request
is a bad scaling model.
Use:
Salesforce Bulk API
for high-volume Salesforce data movement.
Use Mule Batch if you need:
record processing
failure isolation
steps
aggregation
restartability