Key Length in Hashed File
Posted: Wed Aug 29, 2007 8:04 am
Hi,
This is in Correlation to my earlier post but thought it would be helpful to have it seperately.
i) My Hashed file would approximately have 2.5 million records and 67 columns and it was taking ever to write.So I split it into 6 Hashed Files. One thing I have noticed is that my key size (key columns in the Hashed file) are 24 bytes,when I reduce it to 18 bytes they seem to be a bit quicker. Is the key size proportional to the time it takes to build the hashed file.
I did not tune all the parameters and left the default values as it is .
Type :T30 File
Modulus :1
Group Size : 1
Split : 80
Merge : 20 (changed the parameter)
Record Size : 400(changed the parameter)
Large Record :1628
ii) One more thing i noticed is that the same job ran in 25 mins, i believe it is because of the load on the DS server. Is there a way I can check the same.
Thanks,
Vinod
This is in Correlation to my earlier post but thought it would be helpful to have it seperately.
i) My Hashed file would approximately have 2.5 million records and 67 columns and it was taking ever to write.So I split it into 6 Hashed Files. One thing I have noticed is that my key size (key columns in the Hashed file) are 24 bytes,when I reduce it to 18 bytes they seem to be a bit quicker. Is the key size proportional to the time it takes to build the hashed file.
I did not tune all the parameters and left the default values as it is .
Type :T30 File
Modulus :1
Group Size : 1
Split : 80
Merge : 20 (changed the parameter)
Record Size : 400(changed the parameter)
Large Record :1628
ii) One more thing i noticed is that the same job ran in 25 mins, i believe it is because of the load on the DS server. Is there a way I can check the same.
Thanks,
Vinod