dbTalk Databases Forums  

B-tree bulk load/construction

comp.databases.berkeley-db comp.databases.berkeley-db


Discuss B-tree bulk load/construction in the comp.databases.berkeley-db forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roman Dementiev
 
Posts: n/a

Default B-tree bulk load/construction - 06-27-2006 , 09:29 AM






Hi,

I would like to construct a BDB B-tree from a given large set of
key-data pairs. Inserting the pairs incrementally, one by one, is too
slow. Theoretically, the best way to do it is to sort the pairs and
construct B-tree bottom-up at once.

_Question_: does BDB support this way of (bulk) construction? which
methods should be called?


Best,
Roman

PS:
Another solution is to use an external sorter to presort the input and
insert the pairs in ascending order. This will result in near 100 %
cache hits, but is still slower than a bulk construction. This solution
is not good enough for me.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.