diff options
author | Munyoki Kilyungi | 2023-06-15 12:48:15 +0300 |
---|---|---|
committer | Munyoki Kilyungi | 2023-06-15 12:48:15 +0300 |
commit | fc29dfad2078b7e9d5616ac0f8594344471c1758 (patch) | |
tree | 4a9efb0e05c491524aa5b87edf2a8dd8386d673d | |
parent | 9cc17fb22f0300b67730dcae99ede844825ffad8 (diff) | |
download | gn-transform-databases-fc29dfad2078b7e9d5616ac0f8594344471c1758.tar.gz |
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>
-rwxr-xr-x | load-rdf.scm | 1 |
1 files changed, 1 insertions, 0 deletions
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 |