Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tsalesforceinput faster

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 

Labels (2)
1 Reply
Anonymous
Not applicable
Author

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