From 5133e107e51e7e97f40644fc9dcad6a9ba42ac28 Mon Sep 17 00:00:00 2001 From: Samuel Tardieu Date: Fri, 9 May 2014 16:48:04 +0200 Subject: Call vacuum when cleaning the database --- main/src/cgeo/geocaching/DataStore.java | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'main') diff --git a/main/src/cgeo/geocaching/DataStore.java b/main/src/cgeo/geocaching/DataStore.java index c66b653..ba9b133 100644 --- a/main/src/cgeo/geocaching/DataStore.java +++ b/main/src/cgeo/geocaching/DataStore.java @@ -2361,6 +2361,10 @@ public class DataStore { // cleaned. TO BE REMOVED AFTER 2015-03-24. Log.d("Database clean: removing obsolete log images records"); database.delete(dbTableLogImages, "log_id NOT IN (SELECT _id FROM " + dbTableLogs + ")", null); + + // Try to reclaim unused space by compacting the database. + Log.d("Database clean: vacuuming the freed space"); + database.execSQL("VACUUM"); } catch (final Exception e) { Log.w("DataStore.clean", e); } -- cgit v1.1