hello everyone, I use Talend open studio 7.3.1 and
I have a problem with my work when it is scheduled with a windows task, because this is slow and takes a long time to run, while if I run it directly from Talend, the work is fast.
the ETL provides a tDBInput object -> tDBOutput, (database postgres) in the input the query retrieves 190 fields and there are 2 joins, are moved less than 400k records.
Does anyone have suggestions on how to fix my problem?
This is strange. I would expect the precompiled job to run A LOT faster (as it doesn't have to go through the process of compilation first). Two reasons I can think of that might impact performance (off the top of my head) are....
You have scheduled the job to run during particularly busy times for your DBs
You are running it on a different machine with different resources or different network capabilities
thanks for giving me an answer. the server on which I ran the job, in the two modes, is the same only at different times, at a distance of a few minutes between them. As for the database load, there was no stress at that time. this Job is also scheduled during the night time slot (03:00 AM), and the result is always the same, it takes about 3h.
hello, thanks for your reply. i had never tried to manually run the job using the file ". bat", I just made the attempt and the execution happened at the same time as when I launch it from Talend console. what can this mean?
could you try to make a new scheduled task with this job , with no previous task needed to run , you schedule it in the next 5 minute and you'll see if the problem come from the job
Following on from what @guenneguez jeremy said, maybe try adding some logging to the job (if you haven't already). Just something at the very start (using a tPreJob component) and something at the very end (using a tPostJob) component. From what you have both discussed, this looks like it might not be the job you suspect is slow causing the problems here.
