Saket Garg

• Jul 4th, 2006

 

Hi

You can inprove performance of hashed file by

1 .Preloading hash file into memory -->this can be done by enabling preloading options in hash file output stage

2. Write caching options -->.It makes data written into cache before being flushed to disk.you can enable this to ensure that hash files are written in order onto cash before flushed to disk instead of order in which individual rows are written

3 .Preallocating--> Estimating  the approx size   of the hash file so that file need not to be splitted  to often after write operation