Job performance in diferent projects on one server

srinivasthoka · Post by **srinivasthoka** » Tue Oct 10, 2006 6:15 pm

Hi,

I have a DS server job that is giving different performance stats in two different DS projects on the same DS server. Job is giving me 200 rows/sec in one project and the same job is ginving 30 rows/sec in a different project. I tried to make all the project parameters look alike, still the performance is not improving.

Performance is impacted when a Hash file is being looked-up as a lookup file.

Any leads in this regard would be helpful.

Thanks,
Srini

kduke · Post by **kduke** » Tue Oct 10, 2006 6:21 pm

Go into Administrator and see if they are setup the same.

kcbland · Post by **kcbland** » Tue Oct 10, 2006 6:31 pm

Do the jobs in different projects reference the same hashed file, or a copy local to each project? If separate copies, consider the size of the hashed file and its current tuning state. Consider clearing or removing and recreating the files in both projects to have a fair comparison.

ArndW · Post by **ArndW** » Wed Oct 11, 2006 1:05 am

This can happen if one project defaults to using inter-process buffering and the other doesn't and you have a job which benefits by this type of buffering - at a guess a job with a lookup transform stage will most likely be in that category.