0

How many records I can data-load in a single attempt. ?

How many such data-load I can perform in 24 hours.?

I have gone through the documentation, but not sure ( 5 Million ) documentation is talking about per data-loading or in 24 hour time limit.

Requirement is, I need to update around 27 Million record.

0

The 5 million record limit is a Data Loader memory limit, not a Salesforce limit, and I'm pretty sure that's more of a "suggested maximum per file" than a hard limit. The maximum records you can theoretically load in 24 hours is 200 times your API Limit (found in Setup > Company Information). This value is scaled depending on the number of licenses and type of org you have. For example, in a Developer Edition, your theoretical limit would be 3,000,000 records per day (but because of storage limits, is actually just 2,500 records total).

You would need about 135,000 API calls to load 27 million records, which would require you to have about 35 Enterprise Edition licenses or 7 Unlimited Edition licenses (or some other combination), assuming you had no other API traffic that day. Actual API usage may depend on how many triggers/workflow/processes/flows/validation rules/etc you have on the object, as you may get timeout errors with a batch size of 200. Presumably, if your org is large enough to have the storage for 27 million records, you probably have more than enough API calls to load all this data within a 24 hour window.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.