Add a checkpoint after every op.

Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>

1 files changed, 6 insertions, 3 deletions

diff --git a/load-rdf.scm b/load-rdf.scm
index 2ef79ac..20a37db 100755
--- a/load-rdf.scm
+++ b/load-rdf.scm
@@ -45,7 +45,8 @@ authenticating as the dba user with PASSWORD."
      (format out
              "SET DSN=localhost:~a;
 SET PWD=~s;
-DELETE FROM rdf_quad WHERE g = iri_to_id ('~a');"
+DELETE FROM rdf_quad WHERE g = iri_to_id ('~a');
+CHECKPOINT;"
              port
              password
              graph))
@@ -59,7 +60,8 @@ DELETE FROM rdf_quad WHERE g = iri_to_id ('~a');"
      (format out
              "SET DSN=localhost:~a;
 SET PWD=~s;
-DELETE FROM DB.DBA.load_list;"
+DELETE FROM DB.DBA.load_list;
+CHECKPOINT;"
              port
              password))
    OPEN_WRITE
@@ -101,7 +103,6 @@ DB.DBA.XML_SET_NS_DECL ('gnc', 'http://rdf.genenetwork.org/v1/category/', 2);
 DB.DBA.XML_SET_NS_DECL ('gnt', 'http://rdf.genenetwork.org/v1/term/', 2);
 DB.DBA.XML_SET_NS_DECL ('ncbiTaxon', 'https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?mode=Info&id=', 2);
 DB.DBA.XML_SET_NS_DECL ('prism', 'http://prismstandard.org/namespaces/basic/2.0/', 2);
-DB.DBA.XML_SET_NS_DECL ('probeset', 'http://rdf.genenetwork.org/v1/probeset/', 2);
 DB.DBA.XML_SET_NS_DECL ('pubmed', 'http://rdf.ncbi.nlm.nih.gov/pubmed/', 2);
 DB.DBA.XML_SET_NS_DECL ('qb', 'http://purl.org/linked-data/cube#', 2);
 DB.DBA.XML_SET_NS_DECL ('sdmx-measure', 'http://purl.org/linked-data/sdmx/2009/measure#', 2);
@@ -113,6 +114,7 @@ DB.DBA.XML_SET_NS_DECL ('schema', 'https://schema.org/', 2);
 DB.DBA.XML_SET_NS_DECL ('foaf', 'http://xmlns.com/foaf/0.1/#term_', 2);
 DB.DBA.XML_SET_NS_DECL ('gnd', 'https://cd.genenetwork.org/api3/lmdb/v1/data/traits/', 2);
 DB.DBA.XML_SET_NS_DECL ('gn-files', 'http://files.genenetwork.org/current/', 2);
+CHECKPOINT;
 "
              port
              password))
@@ -128,6 +130,7 @@ DB.DBA.XML_SET_NS_DECL ('gn-files', 'http://files.genenetwork.org/current/', 2);
 SET PWD=~s;
 DB.DBA.RDF_OBJ_FT_RULE_ADD (null, null, 'All');
 DB.DBA.VT_INC_INDEX_DB_DBA_RDF_OBJ();
+CHECKPOINT;
 quit;
 "
              port