function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Sean_kSean_k 

Using Java Threads to upload

Hi iam working on a salesforce loader where it involves millions of records to be
inserted/updated/deleted.
With my current design it is taking too much time to load data.I am planning to use Java Threads to
upload records.Can anybody point me to a good example how to create multiple sessions and access them from the
threads.I have gone through the Sforce data loader code but it seems like it is not using the threads.

Thanks
Sean
adamgadamg
How much data are you uploading? Be SURE to use compression on your SOAP stack, use the new upsert call, and use the 7.0 endpoint as all will vastly improve your performance.
SuperfellSuperfell
In addition, make sure you're using HTTP/1.1 persistent connections.
benjasikbenjasik
How many threads are you planning to create? In what timeframe do you need to load this data?
SuperfellSuperfell
Lexi (of SForceDataLoader fame) wrote up a great doc on high performance data loading on the sforce blog. http://blog.sforce.com/sforce/2006/02/data_loading_ma.html, you should make sure you're doing all this before resorting to running parrallel requests.