Hi,
ROS 6.44.3 on CHR
How to do vacuuming right?
Does DB will reduce in it size after vacuuming?
I did it. But it have to "eat" up to 1GB of system partition. Not Dude disk.There is only one vacuum command available so you cannot make a mistake. But it might not help at all. You have to try...
Does it applicable for >6.41 dude installations?
cd C:\path\to\dude\dir\
sqlite3.exe dude.db
DELETE FROM outages;
DELETE FROM chart_values_raw;
DELETE FROM chart_values_10min;
DELETE FROM chart_values_2hour;
DELETE FROM chart_values_1day;
pragma integrity_check;
vacuum;
reindex;
.quit
Of course VACUUM does NOT delete valid data in tables, whether or not anybody considers it unwanted.VACUUM do not do already all?
pragma integrity_check;
vacuum;
reindex;
cd C:\SqlLite3\
echo .dump | sqlite3.exe dude.db > dude.sql
move dude.db dude.db.orig
cd /tmp/
awk '/^INSERT INTO objs/' dude.sql > objs.sql
sqlite3.exe dude.db
pragma integrity_check;
delete from objs;
.read objs.sql
.quit