[tracker/tracker-0.6] Use MEMORY the default pragma for temp_store

[Martyn James Russell <mr src gnome org>]

commit e4c79f9700778faf0ae220d0edc859f6f535cd27
Author: Martyn Russell <martyn imendio com>
Date:   Wed May 27 15:09:54 2009 +0100

    Use MEMORY the default pragma for temp_store
---
 src/libtracker-db/tracker-db-manager.c |    8 +-------
 1 files changed, 1 insertions(+), 7 deletions(-)

diff --git a/src/libtracker-db/tracker-db-manager.c b/src/libtracker-db/tracker-db-manager.c
index d78d650..a68c7ae 100644
--- a/src/libtracker-db/tracker-db-manager.c
+++ b/src/libtracker-db/tracker-db-manager.c
@@ -335,7 +335,7 @@ save_pragma_file_defaults (gboolean safe)
 	g_key_file_set_string (key_file, group, "encoding", "\"UTF-8\"");
 	g_key_file_set_string (key_file, group, "journal_mode", "DELETE");
 	g_key_file_set_string (key_file, group, "synchronous", "NORMAL");
-	g_key_file_set_string (key_file, group, "temp_store", "FILE");
+	g_key_file_set_string (key_file, group, "temp_store", "MEMORY");
 	g_key_file_set_string (key_file, group, "auto_vacuum", "NONE");
 	g_key_file_set_string (key_file, group, "count_changes", "0");
 
@@ -1499,12 +1499,6 @@ db_set_params (TrackerDBInterface *iface,
 		}
 	}
 
-	/* tracker_db_interface_execute_query (iface, NULL, "PRAGMA synchronous = NORMAL;"); */
-	/* tracker_db_interface_execute_query (iface, NULL, "PRAGMA count_changes = 0;"); */
-	/* tracker_db_interface_execute_query (iface, NULL, "PRAGMA temp_store = FILE;"); */
-	/* tracker_db_interface_execute_query (iface, NULL, "PRAGMA encoding = \"UTF-8\""); */
-	/* tracker_db_interface_execute_query (iface, NULL, "PRAGMA auto_vacuum = 0;"); */
-
 	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);