Hi
Can anyone tell what is the maximum number of records that can be kept in a Hash File.
Thanks in Advance
Manoj
Maximum Records possible in a Hash File
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 23
- Joined: Mon Jul 04, 2005 6:25 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.