#26 2008-06-16 16:29:16

amaumont
Talend team
Registered: 2006-09-20
Posts: 471

Re: Performance on a job

Be careful, don't confuse between the key column into a schema and Expression key column into tMap.

Check the Key column from a schema will not improve performance into tMap, yet set an Expression key into one of your lookup will do.

Offline

#27 2008-06-16 16:41:52

suzchr
Member
Registered: 2008-04-30
Posts: 147

Re: Performance on a job

Ok I define a key on my second TMap. I will send the results after.

Thx.

Offline

#28 2008-06-16 17:05:03

catounz
New member
Registered: 2008-05-26
Posts: 7

Re: Performance on a job

Have you tried to load a temporary table as output in the first job ?
Then you could map it with the output table in the 2nd job.

Offline

#29 2008-06-16 17:38:09

maverick
Member
Company: 1913
Registered: 2008-03-27
Posts: 71
Website

Re: Performance on a job

Hi,
Make sure that the metadata schema in yout tMap and in your tAccessOutput match exactly (including datatype) with the schema in your final database


Matthieu Garde
Software development
1913 - L'expertise des PME
www.1913.fr

Offline

#30 2010-08-16 12:01:26

shankar
Guest

Re: Performance on a job

hi can some one tell me how to increase the speed of the rows(no.of.rows) passing in between source to destination...for eg...suppose if a csv file consists more than 1lakhs rows means while running the job..the rows passing in a speed of only 200 rows/s to 300rows/s...how to increase it to more than 1000rows/s...pls anyone reply me...

Board footer

Powered by FluxBB