in reply to Re^4: fast disk db with bulk insert, fast read access, compact storage
in thread fast disk db with bulk insert, fast read access, compact storage

With 1GB of keys averaging 8 chars, that's 128 million key/value pairs.

Yes, that is the key. I guess pun intended here. You enter one char and the field of possibilities narrows, you enter the second char and the field of possibilities narrows further...Goal being to reach a unique key ...

Sounded to me like all that needs to be indexed is the 1GB or ~128M keys. Actual data storage can be on some HD.

  • Comment on Re^5: fast disk db with bulk insert, fast read access, compact storage

In Section Seekers of Perl Wisdom