You need to sign in to do that
Don't have an account?
abc def 8
data loader batch size
hi,
data loader default batch size is 200. one batch is considered as one transaction. so while iam updating 200 records 200th record id is not specified. iam getting 199 successes and one error that is as id is not specified. 199 records are being updated. now my question is batch size is 200 then we dont have problem with 199 records, only we have problem with 200th record then total transaction should be failed. even 199 records should not be processed. process should be rolledback. incase of me why 199 records are being updated. please can any one explain this.
data loader default batch size is 200. one batch is considered as one transaction. so while iam updating 200 records 200th record id is not specified. iam getting 199 successes and one error that is as id is not specified. 199 records are being updated. now my question is batch size is 200 then we dont have problem with 199 records, only we have problem with 200th record then total transaction should be failed. even 199 records should not be processed. process should be rolledback. incase of me why 199 records are being updated. please can any one explain this.
Also, just so you're aware, the batch size can be set up to 2000.
1. All or none commit (This is where all the records would get rolled back if any errored out)
2. Commit all successful (This is where all the successful records will be commited and error would be returned for errored records.
Data loader works with second case.
You can check out this link as well.
https://www.salesforce.com/us/developer/docs/apexcode/Content/apex_methods_system_database.htm#apex_System_Database_insert_2