Hi All,
We have three hash building jobs in our project which is running longer than normal..some day it will run 3 hours and some days it will run 8 hours.
1.PatternHash-(No.of Rec:18330189)
2.Slinhash-(No.of Rec:18300807)
3.UpcHash-(No.of Rec:6631328)
All the above jobs are creating new hash file everyday(Delete before create) as 64 BIT hashed files.
The first job usually runs 2 hours, but it ran 8 hours of the same amount of records in odd days.The same will be applicable to the other two jobs.
We thought all the jobs having the resource contention problem while running in parallel..so we set the predecessor for the jobs. So the above three jobs will run one by one. But no luck on the performance.
Is there any possible way to increase the hash building job performance? kindly suggest you thoughts on this issue.
Thanks,
Satheesh
Hash building job running longer than normal
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am