So we decided to go with Static hashed files and the results have been very good in our test.
In this regard i need more information on how to create the static hashed file during run time depending on the size of the file.
We need to consider the file size, because the file size varies from few thousand records to couple of million records. As part of the process we load entire record into the Hashed file. The size of each record in hashed file is 915 bytes. And the key is Alphanumeric. (Mostly 13 digit telephone number but some times Alphabets come in between).
I want to use mkdbfile utility in creation of Hashed file.
Please let me know what type of file (eg t30, 5, 18 etc), Separation(hash file calculator is suggesting
![Cool 8)](./images/smilies/icon_cool.gif)
I think, modulo is the only thing that varies depending on the size of the file. So i should be able to determine modulo depending on the file size during run time.
Thank You,
Poorna