How to improve performance of tMSSQLinput component

[ERaju1681307967]

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

[Anonymous]

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