dbTalk Databases Forums  

This may seem like a no-brainer to some...

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


Discuss This may seem like a no-brainer to some... in the comp.databases.berkeley-db forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
clayne@anodized.com
 
Posts: n/a

Default This may seem like a no-brainer to some... - 11-21-2005 , 07:29 AM






But I'm astounded at the performance difference I achieved just by
utilizing DB->set_cachesize(). I was attempting to construct a test
database w/ small keys (less than 64 bytes) and data sizes of varying
24-100 bytes or so w/ about 4 million entries (BTREE + DUP + DUPSORT)
and was dumbfounded as to why the process was utilizing 1-5% CPU with
most of it's time spent in uninterruptible sleep.

The second I upped the cache size to 32 megs (from it's default 256k)
the process spent much more useful time actually constructing the
database rather than spinning my disks wheels.

For other BDB novices (like myself) it can be a very useful, but still
overlooked, avenue to explore when trying to profile why things are
taking so long.


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.