Issue 81018

Summary: Compact table menu option
Product: Base Reporter: dlairmarc <marc>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.2.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description dlairmarc 2007-08-25 05:18:35 UTC
A menu tool to compact the tables in an OOo embedded database.


A table which is subject to numerous addition and deletion of records will, over
time, become bloated, thus requiring compaction to reclaim previously used
space. At present, the only way to do this is via the Tool/SQL... option and
create and execute an administrative command: SHUTDOWN COMPACT

While this works, it requires administrative knowledge of SQL commands and is
not intuitive. It also requires exiting OOo and restarting after it completes in
order to use the database.
Comment 1 dlairmarc 2007-08-25 19:49:35 UTC
An additional method using Tools/SQL is to execute SHUTDOWN DEFRAG.
This also compacts the database files but does not require closing the database
and reopening it.
Comment 2 christoph.lukasiak 2007-09-04 15:58:24 UTC
valid enhancement
Comment 3 christoph.lukasiak 2007-09-04 15:59:42 UTC
send further to the requirements team