over: use only supported and safe SQLite APIs

Some of this jankiness was from early performance problems
and they turned out to be unnecessary measures.

1 files changed, 0 insertions, 9 deletions

diff --git a/lib/PublicInbox/OverIdx.pm b/lib/PublicInbox/OverIdx.pm
index 0e43aabc..5c20f1f0 100644
--- a/lib/PublicInbox/OverIdx.pm
+++ b/lib/PublicInbox/OverIdx.pm
@@ -14,21 +14,12 @@ use DBI qw(:sql_types); # SQL_BLOB
 sub dbh_new {
         my ($self) = @_;
         my $dbh = $self->SUPER::dbh_new;
-        $dbh->do('PRAGMA synchronous = OFF'); # commit_fsync instead
         $dbh->do('PRAGMA journal_mode = TRUNCATE');
         $dbh->do('PRAGMA cache_size = 80000');
         create_tables($dbh);
         $dbh;
 }
 
-sub commit_fsync {
-        my $fn = $_[0]->{filename};
-        if (open my $fh, '+<', $fn) {
-                $fh->sync;
-                close $fh;
-        }
-}
-
 sub get_counter ($$) {
         my ($dbh, $key) = @_;
         my $sth = $dbh->prepare_cached(<<'', undef, 1);