[tracker/checkpoint: 5/12] libtracker-data: Change WAL checkpoint threshold to improve performance

[JÃrg Billeter <juergbi src gnome org>]

commit 5abbde5b0d87bc25a9802beecc79aaaaedeea2cd
Author: JÃrg Billeter <j bitron ch>
Date:   Thu Jun 23 13:01:28 2011 +0200

    libtracker-data: Change WAL checkpoint threshold to improve performance

 src/libtracker-data/tracker-db-manager.c |    4 ++++
 1 files changed, 4 insertions(+), 0 deletions(-)
---
diff --git a/src/libtracker-data/tracker-db-manager.c b/src/libtracker-data/tracker-db-manager.c
index 6f0307c..6a1789c 100644
--- a/src/libtracker-data/tracker-db-manager.c
+++ b/src/libtracker-data/tracker-db-manager.c
@@ -267,6 +267,10 @@ db_set_params (TrackerDBInterface   *iface,
 			g_object_unref (stmt);
 		}
 
+		/* increase WAL autocheckpoint threshold from the default of 1000 pages
+		   to 10000 pages to improve update performance */
+		tracker_db_interface_execute_query (iface, NULL, "PRAGMA wal_autocheckpoint = 10000");
+
 		if (page_size != TRACKER_DB_PAGE_SIZE_DONT_SET) {
 			g_message ("  Setting page size to %d", page_size);
 			tracker_db_interface_execute_query (iface, NULL, "PRAGMA page_size = %d", page_size);