From 174ae2304b38a14eaf308323cd9dc31188d56fa8 Mon Sep 17 00:00:00 2001
From: Jens Georg <mail@jensge.org>
Date: Wed, 30 Sep 2009 16:57:46 +0200
Subject: [PATCH] core: add sqlite pragmas

---
 src/rygel/rygel-database.vala | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/src/rygel/rygel-database.vala b/src/rygel/rygel-database.vala
index 0982938..84e6407 100644
--- a/src/rygel/rygel-database.vala
+++ b/src/rygel/rygel-database.vala
@@ -44,6 +44,10 @@ internal class Rygel.Database : Object {
                      db.errmsg ());
             return;
         }
+        this.db.exec ("PRAGMA cache_size = 32768");
+        this.db.exec ("PRAGMA synchronous = OFF");
+        this.db.exec ("PRAGMA temp_store = MEMORY");
+        this.db.exec ("PRAGMA count_changes = OFF");
     }
 
     public int exec (string        sql,
-- 
2.7.4