Good morning all, Sorry to spam the sqlite list but I thought this might be the best place to ask. I'm trying to find an (embedded) database package to fill a specific need and wondered if anyone can provide a recommendation?
Requirements: * disk based storage * As freaking FAST as possible! (this implies a single file for the database, non sparse files are best) * small footprint * can store binary data up to multi megabyte * must be able to quickly locate groups of keys (or provide in order traversal and seek to a substring of a key) * thread safe is optional, but nice * does not need any kind of query language * low numbers of records (100's - 10,000's) * small keys (<100 bytes) * no locking or concurrency * linux and windows compatibility a big plus I'm considering some of the dbm variants but so far only qdbm comes close. I'm doing timing tests on qdbm now but I believe that design has an undesirable feature for my use. It's very fast generally but occasionally takes several seconds (ouch!) to perform a next key retrieval. I believe the btree node retrieval is at fault. Thanks for your help, Jay
