topic tSalesforceInput slow in Talend Studio https://community.qlik.com/t5/Talend-Studio/tSalesforceInput-slow/m-p/2362277#M126442 <P>Hi All,</P><P></P><P></P><P>We are extracting data from Salesforce through tMap then into Snowflake.</P><P></P><P></P><P>We are using tSalesforceInput - tMap - tDBOutput</P><P></P><P></P><P>When we run the job it completes fine but is taken hours to get the data. We have two objects one with 2.1 million rows which is taken 2 1/2 and one with 5 million rows which is taken over 5 hours. It is batching in rows of 250. </P><P></P><P></P><P>The batch size in the tSalesforceInput component is set to 250. If i increase this to 1000 it still only does batches of 250. If i go above 1000 the job errors. </P><P></P><P></P><P>Is there anything i can do to improve the speed?</P> Fri, 15 Nov 2024 23:49:01 GMT JSlatorMHC 2024-11-15T23:49:01Z tSalesforceInput slow https://community.qlik.com/t5/Talend-Studio/tSalesforceInput-slow/m-p/2362277#M126442 <P>Hi All,</P><P></P><P></P><P>We are extracting data from Salesforce through tMap then into Snowflake.</P><P></P><P></P><P>We are using tSalesforceInput - tMap - tDBOutput</P><P></P><P></P><P>When we run the job it completes fine but is taken hours to get the data. We have two objects one with 2.1 million rows which is taken 2 1/2 and one with 5 million rows which is taken over 5 hours. It is batching in rows of 250. </P><P></P><P></P><P>The batch size in the tSalesforceInput component is set to 250. If i increase this to 1000 it still only does batches of 250. If i go above 1000 the job errors. </P><P></P><P></P><P>Is there anything i can do to improve the speed?</P> Fri, 15 Nov 2024 23:49:01 GMT https://community.qlik.com/t5/Talend-Studio/tSalesforceInput-slow/m-p/2362277#M126442 JSlatorMHC 2024-11-15T23:49:01Z Re: tSalesforceInput slow https://community.qlik.com/t5/Talend-Studio/tSalesforceInput-slow/m-p/2362278#M126443 <P>@John Slator​&nbsp;, you can try to use BULK connection option and see how it is performing?</P><P>&nbsp;</P><P>Thanks,</P><P>Manohar</P> Tue, 24 Aug 2021 10:14:37 GMT https://community.qlik.com/t5/Talend-Studio/tSalesforceInput-slow/m-p/2362278#M126443 manodwhb 2021-08-24T10:14:37Z