[rygel] core: add sqlite pragmas



commit 174ae2304b38a14eaf308323cd9dc31188d56fa8
Author: Jens Georg <mail jensge org>
Date:   Wed Sep 30 16:57:46 2009 +0200

    core: add sqlite pragmas

 src/rygel/rygel-database.vala |    4 ++++
 1 files changed, 4 insertions(+), 0 deletions(-)
---
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,



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