<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>How To Use FreeSpacemanager</title>
<link rel="stylesheet" type="text/css" href="../../../style.css">
</head>
<body>
<div class="CommonContent">
<div class="CommonContentArea">
<h1>How To Use FreeSpacemanager</h1>
<p>There are several configuration options that can help you to tune up your freespacemanager to achieve the best performance and reliability of your system. All methods should be called before opening database files.</p>
<p>
Public interface FreespaceConfiguration provides methods to select freespace system ( <i>useIndexSystem() , useRamSystem()</i>) as described before. See API documentation for more information.</p>
<p>
Another FreespaceConfiguration method</p>
<span name="cs_wiki_filter" csw_filters="cs">
<p>c#: </p><p><code>void DiscardSmallerThan(int byteCount) </code></p>
</span>
<span name="cs_wiki_filter" csw_filters="vb">
<p>VB: </p><p><code>void DiscardSmallerThan(int byteCount) </code></p>
</span>
<p>configures the minimum size of free space slots in the database file that are to be reused. FreespaceManager keeps 2 lists of all 'freed' space that can be reused (sorted by address and by size). In some cases (numerous updates, deletes) these lists can grow large, causing extra RAM consumption and performance loss for maintenance. With this method you can specify an upper bound for the byte slot size to discard from Freespace manager list. It is not recommended to specify a value of byteCount > 100 as freespace re-usage will become less efficient and the database file will grow faster. However, if defragment can be run frequently, it will also reclaim lost space and decrease the database file to the minimum size. Therefore byteCount may be set to bigger value.</p>
<p>By default byteCount = 0, which means that all 'freed' space is reused.</p>
<p>
Another configuration setting that can be used with frequently defragmented systems</p>
<span name="cs_wiki_filter" csw_filters="cs">
<p>c#: </p><p><code>configuration.AutomaticShutDown(false);</code></p>
</span>
<span name="cs_wiki_filter" csw_filters="vb">
<p>VB: </p><p><code>configuration.AutomaticShutDown(false);</code></p>
</span>
<p>
Detailed description of this method can be found in <a href="../../tuning/performance_hints/no_shutdown_thread.html" class="wikiLink">Tuning</a> part of the Reference documentation.</p></div>
</div>
<div id="footer">
This revision (15) was last Modified 2007-05-07T12:44:22 by Tetyana.
</div>
</body>
</html>
