Apache OpenOffice (AOO) Bugzilla – Issue 81018
Compact table menu option
Last modified: 2013-02-07 22:32:10 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.
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.
valid enhancement
send further to the requirements team