1<?xml version="1.0" encoding="UTF-8" standalone="no"?> 2<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 3<html xmlns="http://www.w3.org/1999/xhtml"> 4 <head> 5 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> 6 <title>DB->set_h_ffactor()</title> 7 <link rel="stylesheet" href="apiReference.css" type="text/css" /> 8 <meta name="generator" content="DocBook XSL Stylesheets V1.73.2" /> 9 <link rel="start" href="index.html" title="Berkeley DB C API Reference" /> 10 <link rel="up" href="db.html" title="Chapter��2.�� The DB Handle" /> 11 <link rel="prev" href="dbset_h_compare.html" title="DB->set_h_compare()" /> 12 <link rel="next" href="dbset_h_hash.html" title="DB->set_h_hash()" /> 13 </head> 14 <body> 15 <div class="navheader"> 16 <table width="100%" summary="Navigation header"> 17 <tr> 18 <th colspan="3" align="center">DB->set_h_ffactor()</th> 19 </tr> 20 <tr> 21 <td width="20%" align="left"><a accesskey="p" href="dbset_h_compare.html">Prev</a>��</td> 22 <th width="60%" align="center">Chapter��2.�� 23 The DB Handle 24 </th> 25 <td width="20%" align="right">��<a accesskey="n" href="dbset_h_hash.html">Next</a></td> 26 </tr> 27 </table> 28 <hr /> 29 </div> 30 <div class="sect1" lang="en" xml:lang="en"> 31 <div class="titlepage"> 32 <div> 33 <div> 34 <h2 class="title" style="clear: both"><a id="dbset_h_ffactor"></a>DB->set_h_ffactor()</h2> 35 </div> 36 </div> 37 </div> 38 <pre class="programlisting">#include <db.h> 39 40int 41DB->set_h_ffactor(DB *db, u_int32_t h_ffactor); </pre> 42 <p> 43 Set the desired density within the hash table. If no value is 44 specified, the fill factor will be selected dynamically as pages 45 are filled. 46 </p> 47 <p> 48 The density is an approximation of the number of keys allowed to 49 accumulate in any one bucket, determining when the hash table grows or 50 shrinks. If you know the average sizes of the keys and data in your 51 data set, setting the fill factor can enhance performance. A reasonable 52 rule computing fill factor is to set it to the following: 53 </p> 54 <pre class="programlisting"> (pagesize - 32) / (average_key_size + average_data_size + 8) </pre> 55 <p> 56 The <code class="methodname">DB->set_h_ffactor()</code> method configures a database, not only 57 operations performed using the specified 58 <a class="link" href="db.html" title="Chapter��2.�� The DB Handle">DB</a> handle. 59 </p> 60 <p> 61 The <code class="methodname">DB->set_h_ffactor()</code> method may not be called after the 62 <a class="xref" href="dbopen.html" title="DB->open()">DB->open()</a> method is called. If 63 the database already exists when <a class="xref" href="dbopen.html" title="DB->open()">DB->open()</a> 64 is called, the information specified to <code class="methodname">DB->set_h_ffactor()</code> will be ignored. 65 </p> 66 <p> 67 The <code class="methodname">DB->set_h_ffactor()</code> <span> 68 <span> 69 method returns a non-zero error value on failure and 0 on success. 70 </span> 71 72 </span> 73 </p> 74 <div class="sect2" lang="en" xml:lang="en"> 75 <div class="titlepage"> 76 <div> 77 <div> 78 <h3 class="title"><a id="id1647623"></a>Parameters</h3> 79 </div> 80 </div> 81 </div> 82 <div class="sect3" lang="en" xml:lang="en"> 83 <div class="titlepage"> 84 <div> 85 <div> 86 <h4 class="title"><a id="id1647739"></a>h_ffactor</h4> 87 </div> 88 </div> 89 </div> 90 <p> 91 The <span class="bold"><strong>h_ffactor</strong></span> parameter is the 92 desired density within the hash table. 93 </p> 94 </div> 95 </div> 96 <div class="sect2" lang="en" xml:lang="en"> 97 <div class="titlepage"> 98 <div> 99 <div> 100 <h3 class="title"><a id="id1647826"></a>Errors</h3> 101 </div> 102 </div> 103 </div> 104 <p> 105 The <code class="methodname">DB->set_h_ffactor()</code> <span> 106 <span> 107 method may fail and return one of the following non-zero errors: 108 </span> 109 110 </span> 111 </p> 112 <div class="sect3" lang="en" xml:lang="en"> 113 <div class="titlepage"> 114 <div> 115 <div> 116 <h4 class="title"><a id="id1647569"></a>EINVAL</h4> 117 </div> 118 </div> 119 </div> 120 <p> 121 If the method was called after <a class="xref" href="dbopen.html" title="DB->open()">DB->open()</a> 122 was called; or if an invalid flag value or parameter was specified. 123 </p> 124 </div> 125 </div> 126 <div class="sect2" lang="en" xml:lang="en"> 127 <div class="titlepage"> 128 <div> 129 <div> 130 <h3 class="title"><a id="id1647643"></a>Class</h3> 131 </div> 132 </div> 133 </div> 134 <p> 135 <a class="link" href="db.html" title="Chapter��2.�� The DB Handle">DB</a> 136 </p> 137 </div> 138 <div class="sect2" lang="en" xml:lang="en"> 139 <div class="titlepage"> 140 <div> 141 <div> 142 <h3 class="title"><a id="id1647565"></a>See Also</h3> 143 </div> 144 </div> 145 </div> 146 <p> 147 <a class="xref" href="db.html#dblist" title="Database and Related Methods">Database and Related Methods</a> 148 </p> 149 </div> 150 </div> 151 <div class="navfooter"> 152 <hr /> 153 <table width="100%" summary="Navigation footer"> 154 <tr> 155 <td width="40%" align="left"><a accesskey="p" href="dbset_h_compare.html">Prev</a>��</td> 156 <td width="20%" align="center"> 157 <a accesskey="u" href="db.html">Up</a> 158 </td> 159 <td width="40%" align="right">��<a accesskey="n" href="dbset_h_hash.html">Next</a></td> 160 </tr> 161 <tr> 162 <td width="40%" align="left" valign="top">DB->set_h_compare()��</td> 163 <td width="20%" align="center"> 164 <a accesskey="h" href="index.html">Home</a> 165 </td> 166 <td width="40%" align="right" valign="top">��DB->set_h_hash()</td> 167 </tr> 168 </table> 169 </div> 170 </body> 171</html> 172