DSXchange

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

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

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.

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.