While doing data load , in our implementation we have used Console DataLoader. We can also perform the data loading using the API call. Apparently we tested with small sample data using DataLoader and API call. We noticed API call takes lesser time. But API call might need an optimum number of threads and records per thread for a full blown system. Also we have to take care of the complete error handling of data loading (success / failure) and the traceability of those records. With this understanding we think even though console - data loader is taking little more time to load the data, we should use that to ensure other aspect is covered.
Could you please share your recommendation between API call or Data Loader ? What are the advantages of using API call for data loading ? Also will this impact that maximum Limit API call in data ?
------------------------------
Basudha Ghosh
AxTRIA INC
Berkeley Heights
------------------------------