Talend community forum / Post a reply

Open Data SolutionsData Management solutionswarehouseOpen StudioBusinessExtract Transform LoadETL

You are not logged in.

Announcement

[2013-05-06] Boston Area User Group Meetup
[2013-05-02] NOTICE TO ALL TALENDFORGE USERS: maintenance completed
[2013-04-26] Talend Open Studio's 5.3.0 release is available
[2013-04-12] Ready for testing - Talend Open Studio's 5.3.0RC2 release is available
[2013-04-11] Talend’s corporate pages and groups on social media

Unanswered posts

Problem with SELECT a.name AS a_name, b.name AS b_name input by kacper
SayHelloRoute [...] by gary.liu1119@gmail.com
How to generate jar for use with tBRMS by adaemus
Deployment question regarding [...] by rhuiser
General question about jobservers and runtimes ... by rbadev
Using tBRMS / Drools Guvnor by adaemus
Webservice fails to connect on Oracle when running as [...] by anselmopeixoto

Index
» Usage, Operation
» How can i improve the performance

Post a reply

Topic review (newest first)

mpa: 2012-06-14 15:15:10

How long does your sql statement run when running it outside Talend?

Cast as varchar(2000), that's one hell of a long field!

Regards

dylanMa: 2012-06-14 07:36:45

Hi,

I use tMSSQLInput component and query data from MSSQL, and write the query result to disk file,
i have one column type is text, it let the performance is very slowly when is start the job,
need query about nine million records

Server info: Inter(R) Xeon(R) CPU X5670 @2.93GHz 2.93GHz 2.00GHz of RAM

How can i improve the performance?

Announcement

Unanswered posts

Post a reply

Topic review (newest first)

Board footer