[rygel] core: add sqlite pragmas
- From: Zeeshan Ali Khattak <zeeshanak src gnome org>
- To: svn-commits-list gnome org
- Cc:
- Subject: [rygel] core: add sqlite pragmas
- Date: Sat, 24 Oct 2009 14:08:23 +0000 (UTC)
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]