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



commit 768c9f90be1d44208e38284f3e607181d82a38ae
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 9722c36..85bf305 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);



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]