1<!--$Id: db_set_h_ffactor.so,v 10.37 2004/09/28 15:04:19 bostic Exp $--> 2<!--Copyright (c) 1997,2008 Oracle. All rights reserved.--> 3<!--See the file LICENSE for redistribution information.--> 4<html> 5<head> 6<title>Berkeley DB: Db::set_h_ffactor</title> 7<meta name="description" content="Berkeley DB: An embedded database programmatic toolkit."> 8<meta name="keywords" content="embedded,database,programmatic,toolkit,btree,hash,hashing,transaction,transactions,locking,logging,access method,access methods,Java,C,C++"> 9</head> 10<body bgcolor=white> 11<table width="100%"><tr valign=top> 12<td> 13<b>Db::set_h_ffactor</b> 14</td> 15<td align=right> 16<a href="/api_cxx/api_core.html"><img src="/images/api.gif" alt="API"></a> 17<a href="/ref/toc.html"><img src="/images/ref.gif" alt="Ref"></a></td> 18</tr></table> 19<hr size=1 noshade> 20<tt> 21<b><pre> 22#include <db_cxx.h> 23<p> 24int 25Db::set_h_ffactor(u_int32_t h_ffactor); 26<p> 27int Db::get_h_ffactor(u_int32_t *h_ffactorp); 28</pre></b> 29<hr size=1 noshade> 30<b>Description: Db::set_h_ffactor</b> 31<p>Set the desired density within the hash table. If no value is 32specified, the fill factor will be selected dynamically as pages are 33filled.</p> 34<p>The Db::set_h_ffactor method configures a database, not only operations performed 35using the specified <a href="/api_cxx/db_class.html">Db</a> handle.</p> 36<p>The Db::set_h_ffactor method may not be called after the <a href="/api_cxx/db_open.html">Db::open</a> method is called. 37If the database already exists when 38<a href="/api_cxx/db_open.html">Db::open</a> is called, the information specified to Db::set_h_ffactor will 39be ignored. 40</p> 41<p>The Db::set_h_ffactor method 42either returns a non-zero error value 43or throws an exception that encapsulates a non-zero error value on 44failure, and returns 0 on success. 45</p> 46<b>Parameters</b> <br> 47 <b>h_ffactor</b><ul compact><li>The <b>h_ffactor</b> parameter is the desired density within the hash table.</ul> 48<p>The density is an approximation of the number of keys allowed to 49accumulate in any one bucket, determining when the hash table grows or 50shrinks. If you know the average sizes of the keys and data in your 51data set, setting the fill factor can enhance performance. A reasonable 52rule computing fill factor is to set it to the following:</p> 53<blockquote><pre>(pagesize - 32) / (average_key_size + average_data_size + 8)</pre></blockquote> 54<br> 55<br><b>Errors</b> 56<p>The Db::set_h_ffactor method 57may fail and throw 58<a href="/api_cxx/except_class.html">DbException</a>, 59encapsulating one of the following non-zero errors, or return one of 60the following non-zero errors:</p> 61<br> 62<b>EINVAL</b><ul compact><li>If the method was called after <a href="/api_cxx/db_open.html">Db::open</a> was called; or if an 63invalid flag value or parameter was specified.</ul> 64<br> 65<hr size=1 noshade> 66<b>Description: Db::get_h_ffactor</b> 67<p>The Db::get_h_ffactor method returns the hash table density.</p> 68<p>The Db::get_h_ffactor method may be called at any time during the life of the 69application.</p> 70<p>The Db::get_h_ffactor method 71either returns a non-zero error value 72or throws an exception that encapsulates a non-zero error value on 73failure, and returns 0 on success. 74</p> 75<b>Parameters</b> <br> 76 <b>h_ffactorp</b><ul compact><li>The Db::get_h_ffactor method returns the 77hash table density in <b>h_ffactorp</b>.</ul> 78<br> 79<hr size=1 noshade> 80<br><b>Class</b> 81<a href="/api_cxx/db_class.html">Db</a> 82<br><b>See Also</b> 83<a href="/api_cxx/db_list.html">Databases and Related Methods</a> 84</tt> 85<table width="100%"><tr><td><br></td><td align=right> 86<a href="/api_cxx/api_core.html"><img src="/images/api.gif" alt="API"></a><a href="/ref/toc.html"><img src="/images/ref.gif" alt="Ref"></a> 87</td></tr></table> 88<p><font size=1>Copyright (c) 1996,2008 Oracle. All rights reserved.</font> 89</body> 90</html> 91