Maximum Records possible in a Hash File

manojmathai · Post by **manojmathai** » Fri Sep 09, 2005 9:29 pm

Hi

Can anyone tell what is the maximum number of records that can be kept in a Hash File.

Thanks in Advance

Manoj

ray.wurlod · Post by **ray.wurlod** » Sat Sep 10, 2005 2:03 am

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.