topic How to improve performance of tMSSQLinput component in Talend Studio

How to improve performance of tMSSQLinput component

ERaju1681307967 — Tue, 01 Aug 2023 03:04:29 GMT

Hi All,

My requirement is to read data from SQL server table and generate CSV file and so I am using

tMSSQLinput -->tfileoutputdelimit.

But job is running for long time compared to SQL studio( SQL studio it is running for 3 minutes, while in talend it took 20 minutes)

How can we improve the performance in talend.

In Oracle we can give fetch size option in advanced settings. How can we provide fetch size or cursor size option in tMSSQLinput? Are there any other settings we can use to improve the performance.

Thanks for the support in advance

Re: How to improve performance of tMSSQLinput component

Anonymous — Tue, 01 Aug 2023 08:56:18 GMT

Hello @Eaja Raju ,

The tMSSQLInput component use old version of mssql driver,

To improve the performance, it's recommended to download the latest mssql driver 12.2 from

https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server

then install it by the talend Module views on the studio

please refer to the below article

https://help.talend.com/r/en-US/8.0/studio-user-guide/customizing-maven-uri-for-external-module-deployment

Best regards

Aiming