Translations:Faq/Base/123/3/en

    From The Document Foundation Wiki

    SHUTDOWN COMPACT

    Note

    1. 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.
    2. Compaction is particularly necessary for those databases using the integral HSQL engine because the computer needs to keep the entire database in memory.
    3. This latter point makes it particularly useful to make regular backups of the database.