This post have something interesting:
try this on file from DOS command line:
DOS code
C:\Users\Rextended\Desktop\BACKUP\dude>sqlite3 dude.db VACUUM
C:\Users\Rextended\Desktop\BACKUP\dude>sqlite3 dude.db
SQLite version 3.33.0 2020-08-14 13:23:32
Enter ".help" for usage hints.
sqlite> delete from outages;
sqlite> delete from chart_values_raw;
sqlite> delete from chart_values_10min;
sqlite> delete from chart_values_2hour;
sqlite> delete from chart_values_1day;
sqlite> VACUUM;
sqlite>.quit
C:\Users\Rextended\Desktop\BACKUP\dude>
After that fresh start dude service, after full start, stop dude service, after full stop, replace the modified dude.db with the cleaned one, restart dude service