my actual pb is i need a expert advice in selecting the option whether go ahead with hash from a file or hash from database.
Increasing the hardware or rearranging the index can be done to get a faster serach pattern.
I have to do the lookup in database only , but i thought accessing databse for such inflow of records will impact performance.SO i though of option of hash from file/database.
i my case 2600*100 records/min needs to be lookup
and table will have 100k records
i am very bad in network area.