Hi,
I have job which creates hash file, when i run the job for the first time it will run with 8000 rows/sec but when i run the job second time the performance is very slow with 150 rows/sec, i have checked clear file, create file, and delete file in options tab.
I have re designed and also changed the file name but its not working,
Can anybody help me please
Thanks in advance
Regarding Hash file
Moderators: chulett, rschirm, roy
saikir - could you explain how the "Create File" can degrade performance, as I haven't observed that. Sometimes, with large hashed files, the CLEAR.FILE command can take a while; I've found that deleting and re-creating the file can be faster and also will take care of disk space used in the physical OVER.30 file (which doesn't ge "shrunk" on a CLEAR.FILE).
Re: Regarding Hash file
Hi,
During first run i created the file and when i ran second time i removed delete file from options tab and also removed create file. But same problem i faced, When i saw the size of file in unix server after first run it was 2048, But i ran for second file size was blowing up. it was multiplying.
During first run i created the file and when i ran second time i removed delete file from options tab and also removed create file. But same problem i faced, When i saw the size of file in unix server after first run it was 2048, But i ran for second file size was blowing up. it was multiplying.
Re: Regarding Hash file
Hi,
During first run i created the file and when i ran second time i removed delete file from options tab and also removed create file. But same problem i faced, When i saw the size of file in unix server after first run it was 2048, But i ran for second file size was blowing up. it was multiplying.
During first run i created the file and when i ran second time i removed delete file from options tab and also removed create file. But same problem i faced, When i saw the size of file in unix server after first run it was 2048, But i ran for second file size was blowing up. it was multiplying.