tsalesforceinput faster

Anonymous — Sat, 16 Nov 2024 10:45:34 GMT

Hi all

is possible make fast tsalesforceinput -->tmap-->tmysqloutput
i want transfer all salesforce accout to my sql, but is very slow, i have 36 735 account, and talend transfer my rows 6 rows x second, is possible make fast rows x second??

thanks all
and sorry for my bad english

Re: tsalesforceinput faster

Anonymous — Thu, 03 Mar 2016 07:06:13 GMT

Hi,
Have you already tried to store the data on disk instead of memory?
Did you set "Batch Size" in Advanced Setting of tsalesforceinput component which is the number of registrations in each processed batch?
Here is an option "Extend Insert" carry out a bulk insert of a defined set of lines instead of inserting lines one by one.
Could you please check these points to see if there is any improvement?
Best regards
Sabrina

topic tsalesforceinput faster in Talend Studio

tsalesforceinput faster

Re: tsalesforceinput faster