Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Compact table menu option|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description dlairmarc 2007-08-25 05:18:35 UTC
A menu tool to compact the tables in an OOo embedded database. Comment: 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
Comment 3 christoph.lukasiak 2007-09-04 15:59:42 UTC
send further to the requirements team