Not logged in : Login
(Sponging disallowed)

About: VirtTipsAndTricksGuideDeleteLargeGraphs       Sponge   NotDistinct   Permalink

An Entity of Type : atom:Entry, within Data Space : www.openlinksw.com associated with source document(s)
QRcode icon
http://www.openlinksw.com/describe/?url=local%3A%2Fdataspace%2Fdav%2Fwiki%2FMain%2FVirtTipsAndTricksGuideDeleteLargeGraphs

AttributesValues
has container
Date Created
maker
Date Modified
link
id
  • d3147fd893b299d5ba1c00283569828a
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]]
Title
  • VirtTipsAndTricksGuideDeleteLargeGraphs
has creator
is described using
atom:source
atom:updated
  • 2013-08-20T00:37:43Z
atom:title
  • VirtTipsAndTricksGuideDeleteLargeGraphs
links to
atom:author
label
  • VirtTipsAndTricksGuideDeleteLargeGraphs
topic
atom:published
  • 2011-06-11T13:23:34Z
type
is made of
is link of
is creator of of
is atom:contains of
is atom:entry of
is container of of
Faceted Search & Find service v1.17_git122 as of Jan 03 2023


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3330 as of Apr 5 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory, 27 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software