Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Periodic VACUUM; to cleanup the client.db file #123

Open
Hou5e opened this issue Feb 28, 2023 · 1 comment
Open

Periodic VACUUM; to cleanup the client.db file #123

Hou5e opened this issue Feb 28, 2023 · 1 comment
Labels
enhancement New feature or request

Comments

@Hou5e
Copy link
Contributor

Hou5e commented Feb 28, 2023

The client.db file size gets somewhat large over time (like 40-80MB for 50-2k WUs).
The file size was higher on Windows (where more errors happened).
Linux example, 1.5 months of running FAHv8:
image
It could use a periodic SQLite VACUUM; like every 100 WU's, or at startup.
After a vacuum, the database file size goes back to about 48-60KB.

@Hou5e Hou5e changed the title client.db file size grows over time - Could use a periodic VACUUM; Periodic VACUUM; to cleanup the client.db file Feb 28, 2023
@jcoffland jcoffland added the enhancement New feature or request label Mar 19, 2023
@kbernhagen
Copy link
Contributor

Or maybe use PRAGMA auto_vacuum = FULL;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

3 participants