Page 1 of 1
Maximum Records possible in a Hash File
Posted: Fri Sep 09, 2005 9:29 pm
by manojmathai
Hi
Can anyone tell what is the maximum number of records that can be kept in a Hash File.
Thanks in Advance
Manoj
Posted: Sat Sep 10, 2005 2:03 am
by ray.wurlod
Depends on the row size and what size of internal pointer. Therefore an answer in terms of rows (records) is not practicable.
With 32-bit pointers, a hashed file is limited to 2GB of data. With 64-bit pointers, a hashed file is limited theoretically to approximately 19 million TB (though in practice some operating systems will not allow a file of this size, so it's limited typically to about 1 million TB).
Why do you want to know? Just curious.