Skip to Main Content

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database overhead?

Daniel PeeblesApr 17 2007 — edited Apr 19 2007
I'm considering using BDB to store fairly large numbers of keys (mostly RECNO, so 4 bytes) with very simple data (probably 4-8 bytes at the most.) I expect to have around 200k nodes, and was wondering how much space overhead the btree structure would give the file. With 200k nodes, and ~12 bytes per record (key + value,) the basic content of the database would be around 2.3 MB. Would insertion order affect the overhead (i.e. fragmentation, if such a concept is relevant) if I allowed duplicates? I would be adding the records in recno sequential order, so I don't need to worry about allocation of intermediate keys.

Thanks,

Daniel Peebles
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2007
Added on Apr 17 2007
4 comments
946 views