[Prophet] [PATCH] sqlite: Fix pragma name: s/default_synchronous/synchronous/
Cyril Brulebois
kibi at debian.org
Sat Sep 11 06:02:32 EDT 2010
The default_synchronous pragma was removed in 2004 according to the
timeline available on http://www.sqlite.org/, let's use synchronous
instead. See http://www.sqlite.org/pragma.html for sqlite pragmas.
Reminder: Setting it to OFF instead of the default FULL makes Jesse
cry a bit (see eb27c05e52385e059e3a8a679dacea4057c20873), but gives
a huge perf boost.
---
lib/Prophet/Replica/sqlite.pm | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/lib/Prophet/Replica/sqlite.pm b/lib/Prophet/Replica/sqlite.pm
index 256fc3f..6a82c7b 100644
--- a/lib/Prophet/Replica/sqlite.pm
+++ b/lib/Prophet/Replica/sqlite.pm
@@ -29,7 +29,7 @@ has dbh => (
undef, undef,
{ RaiseError => 1, AutoCommit => 1 },
);
- $dbh->do("PRAGMA default_synchronous = OFF");
+ $dbh->do("PRAGMA synchronous = OFF");
};
if ($@) {
die "Unable to open the database file '".$self->db_file
--
1.7.1
More information about the Prophet
mailing list