This HTML5 document contains 32 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

PrefixNamespace IRI
n14http://docs.openlinksw.com/virtuoso/sparqlextensions.html#
dctermshttp://purl.org/dc/terms/
atomhttp://atomowl.org/ontologies/atomrdf#
foafhttp://xmlns.com/foaf/0.1/
n19http://vos.openlinksw.com/dataspace/services/wiki/
oplhttp://www.openlinksw.com/schema/attribution#
n2http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
dchttp://purl.org/dc/elements/1.1/
n6http://vos.openlinksw.com/dataspace/dav#
rdfshttp://www.w3.org/2000/01/rdf-schema#
n20http://rdfs.org/sioc/services#
siocthttp://rdfs.org/sioc/types#
n10http://vos.openlinksw.com/dataspace/person/dav#
n9http://vos.openlinksw.com/dataspace/owiki/wiki/
n18http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtTipsAndTricksGuideDeleteLargeGraphs/sioc.
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n13http://docs.openlinksw.com/virtuoso/fn_log_enable.
n4http://vos.openlinksw.com/dataspace/owiki#
xsdhhttp://www.w3.org/2001/XMLSchema#
n8http://vos.openlinksw.com/dataspace/person/owiki#
siochttp://rdfs.org/sioc/ns#
Subject Item
n10:this
foaf:made
n2:VirtTipsAndTricksGuideDeleteLargeGraphs
Subject Item
n6:this
sioc:creator_of
n2:VirtTipsAndTricksGuideDeleteLargeGraphs
Subject Item
n19:item
n20:services_of
n2:VirtTipsAndTricksGuideDeleteLargeGraphs
Subject Item
n4:this
sioc:creator_of
n2:VirtTipsAndTricksGuideDeleteLargeGraphs
Subject Item
n9:VOS
sioc:container_of
n2:VirtTipsAndTricksGuideDeleteLargeGraphs
atom:entry
n2:VirtTipsAndTricksGuideDeleteLargeGraphs
atom:contains
n2:VirtTipsAndTricksGuideDeleteLargeGraphs
Subject Item
n2:VirtTipsAndTricksGuideDeleteTriplesWithBlanknodes
sioc:links_to
n2:VirtTipsAndTricksGuideDeleteLargeGraphs
Subject Item
n2:VirtTipsAndTricksGuideDeleteLargeGraphs
rdf:type
atom:Entry sioct:Comment
dcterms:created
2017-06-13T05:43:33.691574
dcterms:modified
2017-06-13T05:43:33.691574
rdfs:label
VirtTipsAndTricksGuideDeleteLargeGraphs
foaf:maker
n8:this n10:this
dc:title
VirtTipsAndTricksGuideDeleteLargeGraphs
opl:isDescribedUsing
n18:rdf
sioc:has_creator
n6:this n4:this
sioc:content
%META:TOPICPARENT{name="VirtTipsAndTricksGuide"}% --+ How can I delete graphs containing large numbers of triples from the Virtuoso Quad Store? By default, triple deletion is performed as part of a transaction, which is stored in memory until the operation is completed and committed to the database. During typical server operation, deleting one or more graphs containing a large number of triples (generally millions or more) can consume available memory to the point where the operation <i>cannot</i> be completed, and thus the graph(s) cannot be deleted. Such large graphs can be cleared by changing the transaction log mode to <code>autocommit</code> on each operation, deleting the graph(s) or triples. This is easily done using the Virtuoso <code>[[http://docs.openlinksw.com/virtuoso/fn_log_enable.html][log_enable]]</code> function, with the settings <code>log_enable(3,1)</code>. This function may be called on its own, prior to the delete operation, via iSQL (either command-line or the Conductor variant), as shown: <verbatim> log_enable(3,1); SPARQL CLEAR GRAPH <graph-name>; </verbatim> <code>log_enable()</code> may also be called as a pragma specified in a SPARUL query: <verbatim> SPARQL DEFINE sql:log-enable 3 CLEAR GRAPH <graph-name>; </verbatim> Triples can also be deleted directly from the <code>RDF_QUAD</code> table via SQL, but note that this method will not remove any free-text index data that might be associated with the graph, which <code>CLEAR GRAPH ...</code> would do automatically. The SQL operation would look something like this: <verbatim> log_enable(3,1); DELETE FROM rdf_quad WHERE g = iri_to_id ('http://mygraph.org'); </verbatim> ---++ Related * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Guide]] * [[http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparul][Virtuoso SPARUL Update Language For RDF Graphs]]
sioc:id
ac4c748989cb2b1323990a5279ab33e8
sioc:link
n2:VirtTipsAndTricksGuideDeleteLargeGraphs
sioc:has_container
n9:VOS
n20:has_services
n19:item
atom:title
VirtTipsAndTricksGuideDeleteLargeGraphs
sioc:links_to
n13:html n14:rdfsparul
atom:source
n9:VOS
atom:author
n10:this
atom:published
2017-06-13T05:43:33Z
atom:updated
2017-06-13T05:43:33Z
sioc:topic
n9:VOS