in reply to Hash tables, are they really what we see?
Hello.
I did some benchmark for perl hash vs in-memory SQLite several days ago. Number of records that you are interested seems similar with my case, have a look at this thread if you are interested in.
Hash lookup is fast. There are cases in-memory sqlite is better than hash.
In Section
Seekers of Perl Wisdom