Do you actually think having a hastable is better than having a DB?
The hashtable will have 17 digits in a row, that means 17*100 million approx 1.7GB of RAM.
I do have a larger RAM size on my machine.
Why do you say that
If it has to page to disk, you might as well not be caching.
I want to minimize the disk i/o that is why I want the hashtable in cache. When an update happens (which is very infrequent), I update the table on the disk and then cache it.
Also, how do I cache the Properties/Hashtable? By running the program once? Is there any way to make sure that the table remains cached?
I will also look at the nosql databases.