64-bit hashed files

Pete Morris · Post by **Pete Morris** » Tue Jun 19, 2007 5:33 am

If a hashed file is converted to 64-bit do all the DS jobs that access the file need recompiling.

Also are there performance implications of using 64-bit hashed files.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 19, 2007 5:48 am

1. No.
2. Define performance. Obviously the storage space will go up, since you now have three eight-byte pointers per record rather than three four-byte pointers per record. The perfect world scenario (a perfectly tuned hashed file) will continue to require 1.0 logical I/O operations per key access when used in a lookup. And the best "performance" boost of all is that your job won't abort when you go over 2GB.