Data Import : Want to know limit on Number of Records
I have over 0.5 million records to be updated as a part of data fix on standard object. I am aware about multiple ways to do it i.e. using Data Import wizard, REST API, SOAP API.
Data Import Wizard has a limitation of processing capacity of 10,000 records in one go. So running it 50+ times to load 0.5 million is not ideal. I would like to know if there is a most efficient way to process 5 Lac records. And if there is any limitation on number of records using REST and SOAP API (I think there shouldn't be but want to confirm).