=== modified file 'configure.ac' --- configure.ac 2012-03-19 22:21:54 +0000 +++ configure.ac 2012-06-03 11:58:32 +0000 @@ -119,7 +119,7 @@ IT_PROG_INTLTOOL([0.35.0]) # required versions -SQLITE_REQUIRED=3.0 +SQLITE_REQUIRED=3.7.0 GTKMM_REQUIRED=2.12.0 GLIBMM_REQUIRED=2.12.0 GIOMM_REQUIRED=2.10.0 === modified file 'control' --- control 2012-03-11 22:20:20 +0000 +++ control 2012-06-03 11:51:58 +0000 @@ -4,7 +4,7 @@ Maintainer: me-tv team Build-Depends: debhelper (>= 7.0.50~), autotools-dev, pkg-config, intltool, libgtkmm-2.4-dev (>=2.12), libx11-dev, - libsqlite3-dev, libgconfmm-2.6-dev, libunique-dev, + libsqlite3-dev (>=3.7.0), libgconfmm-2.6-dev, libunique-dev, libdbus-glib-1-dev, libxml++2.6-dev, libvlc-dev, libgstreamer0.10-dev, libgstreamer-plugins-base0.10-dev Standards-Version: 3.9.1 === modified file 'server/data.cc' --- server/data.cc 2012-03-19 22:21:54 +0000 +++ server/data.cc 2012-06-03 11:53:34 +0000 @@ -74,6 +74,8 @@ { throw SQLiteException(connection, _("Failed to finalise statement")); } + + statement = NULL; } void Statement::reset() @@ -178,6 +180,21 @@ } database_created = !database_exists; + + // Enable WAL journal + Statement* stmnt = new Statement(*this, "PRAGMA journal_mode=WAL"); + stmnt->step(); + delete stmnt; + + // Set page size + stmnt = new Statement(*this, "PRAGMA page_size=8192"); + stmnt->step(); + delete stmnt; + + // Synchronous mode + stmnt = new Statement(*this, "PRAGMA synchronous=NORMAL"); + stmnt->step(); + delete stmnt; } Connection::~Connection()