https://neowiki.neooffice.org/index.php?title=Compacting_your_database&action=history&feed=atomCompacting your database - Revision history2024-03-28T21:24:50ZRevision history for this page on the wikiMediaWiki 1.10.1https://neowiki.neooffice.org/index.php?title=Compacting_your_database&diff=15518&oldid=prevSardisson: minor stylistic tweaks2009-10-22T23:02:55Z<p>minor stylistic tweaks</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 23:02, 22 October 2009</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">In the database engine embedded in Base, when records are deleted they are unlinked in the actual tables. The space used by them is not automatically freed and the indexes can be become fragmented over time. </td><td>+</td><td style="background: #cfc; font-size: smaller;">In the database engine embedded in Base, when records are deleted they are unlinked in the actual tables. The space used by them is not automatically freed and the indexes can be become fragmented over time<ins style="color: red; font-weight: bold; text-decoration: none;">. This leads to a degradation of performance</ins>.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">This leads to a degradation of performance. </del></td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">==Reclaiming Space and Repacking Indexes==</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">There are two ways to reclaim this space and repack the indexes. </td><td> </td><td style="background: #eee; font-size: smaller;">There are two ways to reclaim this space and repack the indexes. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">The first is to execute the SQL command</td><td>+</td><td style="background: #cfc; font-size: smaller;">The first is to execute the SQL command<ins style="color: red; font-weight: bold; text-decoration: none;"><br></ins></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><tt>SHUTDOWN COMPACT</tt></td><td>+</td><td style="background: #cfc; font-size: smaller;"><tt>SHUTDOWN COMPACT</tt<ins style="color: red; font-weight: bold; text-decoration: none;">><br</ins>></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">The disadvantage of this is that the database engine is, well shutdown. So the Base file would need to be closed and reopened. </td><td> </td><td style="background: #eee; font-size: smaller;">The disadvantage of this is that the database engine is, well shutdown. So the Base file would need to be closed and reopened. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">The other is to execute this SQL command </td><td>+</td><td style="background: #cfc; font-size: smaller;">The other is to execute this SQL command<ins style="color: red; font-weight: bold; text-decoration: none;"><br> </ins></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><tt>CHECKPOINT DEFRAG</tt></td><td>+</td><td style="background: #cfc; font-size: smaller;"><tt>CHECKPOINT DEFRAG</tt<ins style="color: red; font-weight: bold; text-decoration: none;">><br</ins>></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">In this case the engine is also shutdown to active connections, the space used by deleted records reclaimed and the indexes rebuilt. The engine is then automatically restarted. </td><td> </td><td style="background: #eee; font-size: smaller;">In this case the engine is also shutdown to active connections, the space used by deleted records reclaimed and the indexes rebuilt. The engine is then automatically restarted. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">Either of these commands can be entered by hand in the SQL window. <del style="color: red; font-weight: bold; text-decoration: none;">(''From the [http://www.oooforum.org/forum/viewtopic.phtml?t=61295 OpenOffice.org Forum''])</del></td><td>+</td><td style="background: #cfc; font-size: smaller;">Either of these commands can be entered by hand in the SQL window.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">To enter the command by hand begin in your main database window. In the {{menu|Tools}} menu choose {{menu|SQL…}}. This brings up an {{Window|Execute SQL Statement}} window. Type the command into the window and then click {{button|Execute}}.</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">===Entering the SQL Commands===</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"> </td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">To enter the command by hand<ins style="color: red; font-weight: bold; text-decoration: none;">, </ins>begin in your main database window. In the {{menu|Tools}} menu<ins style="color: red; font-weight: bold; text-decoration: none;">, </ins>choose {{menu|SQL…}}. This brings up an {{Window|Execute SQL Statement}} window. Type the command into the window and then click {{button|Execute}}.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"> </td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">==References==</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">* [http://www.oooforum.org/forum/viewtopic.phtml?t=61295 OpenOffice.org Forum]</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips_and_Hints]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips_and_Hints]]</td></tr>
</table>Sardissonhttps://neowiki.neooffice.org/index.php?title=Compacting_your_database&diff=15517&oldid=prevJames3359 at 10:14, 22 October 20092009-10-22T10:14:28Z<p></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 10:14, 22 October 2009</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 5:</strong></td>
<td colspan="2" align="left"><strong>Line 5:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">There are two ways to reclaim this space and repack the indexes. </td><td> </td><td style="background: #eee; font-size: smaller;">There are two ways to reclaim this space and repack the indexes. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">The first is to execute the command</td><td>+</td><td style="background: #cfc; font-size: smaller;">The first is to execute the <ins style="color: red; font-weight: bold; text-decoration: none;">SQL </ins>command</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"><tt>SHUTDOWN COMPACT</tt></td><td> </td><td style="background: #eee; font-size: smaller;"><tt>SHUTDOWN COMPACT</tt></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">The disadvantage of this is that the database engine is, well shutdown. So the Base file would need to be closed and reopened. </td><td> </td><td style="background: #eee; font-size: smaller;">The disadvantage of this is that the database engine is, well shutdown. So the Base file would need to be closed and reopened. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">The other is to execute this command </td><td>+</td><td style="background: #cfc; font-size: smaller;">The other is to execute this <ins style="color: red; font-weight: bold; text-decoration: none;">SQL </ins>command </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"><tt>CHECKPOINT DEFRAG</tt></td><td> </td><td style="background: #eee; font-size: smaller;"><tt>CHECKPOINT DEFRAG</tt></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">In this case the engine is also shutdown to active connections, the space used by deleted records reclaimed and the indexes rebuilt. The engine is then automatically restarted. </td><td> </td><td style="background: #eee; font-size: smaller;">In this case the engine is also shutdown to active connections, the space used by deleted records reclaimed and the indexes rebuilt. The engine is then automatically restarted. </td></tr>
</table>James3359https://neowiki.neooffice.org/index.php?title=Compacting_your_database&diff=15516&oldid=prevJames3359: This is a new page(!) with instructions about how to use SQL commands to compact a database.2009-10-22T10:13:47Z<p>This is a new page(!) with instructions about how to use SQL commands to compact a database.</p>
<p><b>New page</b></p><div>In the database engine embedded in Base, when records are deleted they are unlinked in the actual tables. The space used by them is not automatically freed and the indexes can be become fragmented over time. <br />
<br />
This leads to a degradation of performance. <br />
<br />
There are two ways to reclaim this space and repack the indexes. <br />
<br />
The first is to execute the command<br />
<tt>SHUTDOWN COMPACT</tt><br />
The disadvantage of this is that the database engine is, well shutdown. So the Base file would need to be closed and reopened. <br />
<br />
The other is to execute this command <br />
<tt>CHECKPOINT DEFRAG</tt><br />
In this case the engine is also shutdown to active connections, the space used by deleted records reclaimed and the indexes rebuilt. The engine is then automatically restarted. <br />
<br />
Either of these commands can be entered by hand in the SQL window. (''From the [http://www.oooforum.org/forum/viewtopic.phtml?t=61295 OpenOffice.org Forum''])<br />
<br />
To enter the command by hand begin in your main database window. In the {{menu|Tools}} menu choose {{menu|SQL…}}. This brings up an {{Window|Execute SQL Statement}} window. Type the command into the window and then click {{button|Execute}}.<br />
<br />
[[Category:NeoOffice]][[Category:Tips_and_Hints]]</div>James3359