tsalesforceinput faster

One Star

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 

Moderator

Re: tsalesforceinput faster

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now