# How long to compact, and why no logging? Is it stuck?

**URL:** https://forum.duplicati.com/t/how-long-to-compact-and-why-no-logging-is-it-stuck/12785
**Category:** Support
**Created:** [July 27, 2021, 4:12pm UTC](https://forum.duplicati.com/t/how-long-to-compact-and-why-no-logging-is-it-stuck/12785 "2021-07-27T16:12:13Z")
**Posts on this page:** 1
**Showing post:** 36

<div class="post-metadata">

### Author: ![warwickmm](https://forum.duplicati.com/letter_avatar_proxy/v4/letter/w/5e9695/32.png) [@warwickmm](https://forum.duplicati.com/u/warwickmm)
#### Post date: [August 1, 2021, 8:38pm UTC](https://forum.duplicati.com/t/how-long-to-compact-and-why-no-logging-is-it-stuck/12785/36 "2021-08-01T20:38:21Z")

</div>

> -rw-------. 1 root root 233472 2021-07-29 10:20:00.149070786 -0400 Duplicati-server.sqlite  
> -rw-------. 1 root root 18098118656 2021-07-29 02:34:19.850664721 -0400 MYFGVUULA.sqlite

This is quite a large database. You might want to try a VACUUM operation to see if that helps. Make sure that you have at least 2x the database size in free space in your temporary directory before doing so.

> [@VACUUM - performance improvement is huge](https://forum.duplicati.com/t/vacuum-performance-improvement-is-huge/5186/19):
>
> Friends searching Google on Duplicati’s vaccum, I found this from here: [SQLite VACUUM](https://www.tutorialspoint.com/sqlite/sqlite_vacuum.htm) After reading the article, I decided to test on a client that has a database of 163MB, I ran the following command: sqlite3 72667174897076837983.sqlite VACUUM; After running this command, the database was cleaned up to a size of 145MB. With the vacuum done, I did the test trying to run the Backup Job again and it ran 100% without fail. \o/ In this way, I believe that at least for me, it is more feasible to…

> **[SQLite - VACUUM](https://www.tutorialspoint.com/sqlite/sqlite_vacuum.htm)**
>
> SQLite VACUUM - VACUUM command cleans the main database by copying its contents to a temporary database file and reloading the original database file from the copy. This eliminates free pages, aligns table data to be contiguous, and otherwise cleans...

> **[Advanced Options - Duplicati 2 User's Manual](https://duplicati.readthedocs.io/en/latest/06-advanced-options/#auto-vacuum)**
>
> Documentation for Duplicati 2

---

_[View the full topic](https://forum.duplicati.com/t/how-long-to-compact-and-why-no-logging-is-it-stuck/12785)._