Hashed File Settings
Posted: Tue Mar 27, 2007 11:02 pm
We are working in product development, so we are having some problem with the initial settings of the Hashed File.And we will always use the Dynamic Hashed File only.
Let me take the example of employee table, as the employee count will differ from customer to customer. Let me assume one customer is having 10,000 rows and another customer is having 1,000,000 rows in the employee table.
So now for building the Hashed file which settings i have to choose.In Hashed File Calculator for "the number of records" , whether i have to give 1,000,000 or 10,000. based upon the number of records the MINIMUM MODULUS is changing.
What will be the best settings for me in this case? and let me assume i am building my hashed file based on 1,000,000 records. whether my performance will be less , if we have only 10,000 records in my hashed file or when it exceeds 1,000,000 records.
Please advice
Let me take the example of employee table, as the employee count will differ from customer to customer. Let me assume one customer is having 10,000 rows and another customer is having 1,000,000 rows in the employee table.
So now for building the Hashed file which settings i have to choose.In Hashed File Calculator for "the number of records" , whether i have to give 1,000,000 or 10,000. based upon the number of records the MINIMUM MODULUS is changing.
What will be the best settings for me in this case? and let me assume i am building my hashed file based on 1,000,000 records. whether my performance will be less , if we have only 10,000 records in my hashed file or when it exceeds 1,000,000 records.
Please advice