topic Performance issue with MSSQL data loading to file in Talend Studio

Performance issue with MSSQL data loading to file

MaheswarReddy — Sat, 16 Nov 2024 03:37:14 GMT

Hi Team,

I just have a simple one to one map from tMSSQLInput to tfileOutput (Simple one to one) Shown in the picture,

The time it takes is huge for to load directly into the file, Is there any way to improve performance ?

I can load only 2500 rows per second , Is there any way that i can improve performance ?

Please let me know.

Thanks

Re: Performance issue with MSSQL data loading to file

Anonymous — Fri, 10 Jan 2020 18:26:54 GMT

Hi,

The first thing I would recommend is to verify the execution plan of the query to make sure that its optimal in nature. If it needs tuning, I would recommend to get the help of a DBA to tweak it before running it in Talend.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved