[tracker/tracker-0.12] libtracker-data: Set journal_size_limit to 10 MB

[Martyn James Russell <mr src gnome org>]

commit cf427fdc3153319d694830a753c136d758430a32
Author: JÃrg Billeter <j bitron ch>
Date:   Tue Sep 27 15:57:33 2011 +0200

    libtracker-data: Set journal_size_limit to 10 MB
    
    The WAL file may grow larger than that temporarily, but SQLite will
    truncate it to 10 MB as soon as it can.

 src/libtracker-data/tracker-db-manager.c |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)
---
diff --git a/src/libtracker-data/tracker-db-manager.c b/src/libtracker-data/tracker-db-manager.c
index c88a960..ca0f19b 100644
--- a/src/libtracker-data/tracker-db-manager.c
+++ b/src/libtracker-data/tracker-db-manager.c
@@ -273,6 +273,8 @@ db_set_params (TrackerDBInterface   *iface,
 		/* disable autocheckpoint */
 		tracker_db_interface_execute_query (iface, NULL, "PRAGMA wal_autocheckpoint = 0");
 
+		tracker_db_interface_execute_query (iface, NULL, "PRAGMA journal_size_limit = 10240000");
+
 		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);