Brackup way faster with SQLite "synchronous = OFF"
brad at danga.com
Mon Oct 15 07:29:32 UTC 2007
Nice find! I'll make this an option.
On Mon, 8 Oct 2007, Max Kanat-Alexander wrote:
> This probably isn't the "safest" way to backup, but for initial
> backups, I've discovered that brackup is WAY faster (A 7x improvement
> on my machine) with these three lines in Brackup::Dict::SQLite right
> before "return $self". I suspect the real speed gain is from
> "synchronous = OFF":
> $dbh->do("PRAGMA locking_mode = EXCLUSIVE");
> $dbh->do("PRAGMA read_uncommitted = 1");
> $dbh->do("PRAGMA synchronous = OFF");
> Competent, Friendly Bugzilla Services. And Everything Else, too.
More information about the brackup