Not logged in : Login

About: VirtTipsAndTricksGuideTransactionLogControl     Goto   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=http%3A%2F%2Fwww.openlinksw.com%2Fdataspace%2Fdav%2Fwiki%2FMain%2FVirtTipsAndTricksGuideTransactionLogControl

AttributesValues
has container
Date Created
maker
topic
described by
seeAlso
Date Modified
link
id
  • c98b160512e706522cbb426fe7295d41
content
  • %META:TOPICPARENT{name="VirtTipsAndTricksGuide"}% ---+ How can I perform SPARQL Updates without exceeding transactional log size? SPARUL updates are generally not meant to be transactional. To prevent running out of rollback space, it is usually best to tell Virtuoso to commit each operation as it is done, with this SQL call: <verbatim> SQL> log_enable (2); </verbatim> Transaction logging can also be turned off for [[VirtBulkRDFLoader][bulk updates]]. In such case, one should do a manual checkpoint after the bulk insert operation, to ensure persistence across server restart, since there will be no roll forward log. If you're only occasionally exceeding the configured transactional log size, you may prefer to set the "<b>TransactionAfterImageLimit</b>" parameter in the virtuoso.ini config file to a higher value than its 50MB default: <verbatim> #virtuoso.ini ... [Parameters] ... TransactionAfterImageLimit = 99999999 ; bytes default 50000000 ... </verbatim> ---++ Related * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]] * [[http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfsparul][Using SPARUL]] * [[http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#ini_Parameters][Virtuoso INI Parameters]]
Title
  • VirtTipsAndTricksGuideTransactionLogControl
has creator
is described using
atom:source
atom:updated
  • 2013-09-17T14:10:53Z
atom:title
  • VirtTipsAndTricksGuideTransactionLogControl
links to
atom:author
label
  • VirtTipsAndTricksGuideTransactionLogControl
topic
atom:published
  • 2011-02-28T05:58:22Z
type
is topic of
is interest of
Faceted Search & Find service v1.17_git63 as of Apr 23 2021


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:       RDF       ODATA       Microdata      About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3322 as of Jun 3 2021, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2021 OpenLink Software