summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJiří Techet <techet@gmail.com>2013-08-06 21:41:42 +0200
committerJiří Techet <techet@gmail.com>2013-08-07 13:37:07 +0200
commit55826b81be9bd911650f246f0d15e29e0851ef01 (patch)
tree2864118dc84ba9b882597f945c5ab073bd5efaf5
parent10378bfff25a7c8c092d0a348d4f0c81765460b2 (diff)
downloadlibchamplain-55826b81be9bd911650f246f0d15e29e0851ef01.tar.gz
Remove deprecated count_changes pragma and perform database vacuum on demand
-rw-r--r--champlain/champlain-file-cache.c4
1 files changed, 3 insertions, 1 deletions
diff --git a/champlain/champlain-file-cache.c b/champlain/champlain-file-cache.c
index 963cfa0..6a4cb9e 100644
--- a/champlain/champlain-file-cache.c
+++ b/champlain/champlain-file-cache.c
@@ -223,7 +223,7 @@ init_cache (ChamplainFileCache *file_cache)
sqlite3_exec (priv->db,
"PRAGMA synchronous=OFF;"
- "PRAGMA count_changes=OFF;",
+ "PRAGMA auto_vacuum=INCREMENTAL;",
NULL, NULL, &error_msg);
if (error_msg != NULL)
{
@@ -1014,4 +1014,6 @@ champlain_file_cache_purge (ChamplainFileCache *file_cache)
sqlite3_free (error);
}
sqlite3_free (query);
+
+ sqlite3_exec (priv->db, "PRAGMA incremental_vacuum;", NULL, NULL, &error);
}