Translations:Faq/Base/123/3/en
SHUTDOWN COMPACT
Note
- Although these two instructions have roughly the same effect of reducing the size, the second (SHUTDOWN COMPACT) will be followed immediately by a disconnection from the database because it effects a disconnection from the data source.
- Compaction is particularly necessary for those databases using the integral HSQL engine because the computer needs to keep the entire database in memory.
- This latter point makes it particularly useful to make regular backups of the database.