What does 'Vacuum' do in Menial's Base 2 application?
DISCLAIMER : Not a Menial Base 2 person
VACUUM is a sqlite operation for defragmenting tables and tablespaces. It also helps reclaim diskspace.
It defragments all sqlite tables by copying data from the sqlite tables to a temp tablespace. The VACUUM operation will then swap out the old tablespace and use the new one. Database pages lost due to DELETEs and UPDATEs will no longer exist.
MONyog also uses sqlite tables for collecting database statistics and features a VACUUM operation.