# VACUUM - performance improvement is huge

**URL:** https://forum.duplicati.com/t/vacuum-performance-improvement-is-huge/5186
**Category:** Developer
**Created:** [November 4, 2018, 11:25am UTC](https://forum.duplicati.com/t/vacuum-performance-improvement-is-huge/5186 "2018-11-04T11:25:26Z")
**Posts on this page:** 1
**Showing post:** 19

<div class="post-metadata">

### Author: ![tacioandrade](https://forum.duplicati.com/user_avatar/forum.duplicati.com/tacioandrade/32/641_2.png) [@tacioandrade](https://forum.duplicati.com/u/tacioandrade)
#### Post date: [November 22, 2018, 4:28am UTC](https://forum.duplicati.com/t/vacuum-performance-improvement-is-huge/5186/19 "2018-11-22T04:28:42Z")

</div>

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 run the vaccum outside of Duplicati via script (powershell or shell script), than with Duplicati.CommandLine.exe

---

_[View the full topic](https://forum.duplicati.com/t/vacuum-performance-improvement-is-huge/5186)._