fah-client-bastet icon indicating copy to clipboard operation
fah-client-bastet copied to clipboard

Periodic `VACUUM;` to cleanup the client.db file

Open Hou5e opened this issue 2 years ago • 1 comments

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 avatar Feb 28 '23 13:02 Hou5e

Or maybe use PRAGMA auto_vacuum = FULL;

kbernhagen avatar Apr 30 '23 10:04 kbernhagen