From fc29dfad2078b7e9d5616ac0f8594344471c1758 Mon Sep 17 00:00:00 2001
From: Munyoki Kilyungi
Date: Thu, 15 Jun 2023 12:48:15 +0300
Subject: Change the transaction log mode to 'autocommit' when deleting graph

During typical server operations, deleting one or more graphs
containing a large number of triples can consume available memory to
the point where the operation cannot be completed, and thus the graph
can't be deleted.  Such large graphs can be cleared by changing the
transaction log mode to autocommit.  Read the following for more:

    https://vos.openlinksw.com/owiki/wiki/VOS/VirtTipsAndTricksGuideDeleteLargeGraphs

Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
---
 load-rdf.scm | 1 +
 1 file changed, 1 insertion(+)

(limited to 'load-rdf.scm')

diff --git a/load-rdf.scm b/load-rdf.scm
index e07665f..b5ed5ac 100755
--- a/load-rdf.scm
+++ b/load-rdf.scm
@@ -155,6 +155,7 @@ authenticating as the dba user with PASSWORD."
      (format out
              "SET DSN=localhost:~a;
 SET PWD=~s;
+log_enable(3, 1);
 DELETE FROM rdf_quad WHERE g = iri_to_id ('~a');"
              port
              password
-- 
cgit v1.2.3