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

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

Subject Item

n2:VirtTipsAndTricksGuideTransactionLogControl

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T05:47:39.515722

dcterms:modified

2017-06-13T05:47:39.515722

rdfs:label

VirtTipsAndTricksGuideTransactionLogControl

foaf:maker

n8:this n15:this

dc:title

VirtTipsAndTricksGuideTransactionLogControl

opl:isDescribedUsing

n20:rdf

sioc:has_creator

n11:this n21:this

sioc: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]]

sioc:id

b3651ef6c3e22336a416cd261318e5b1

sioc:link

n2:VirtTipsAndTricksGuideTransactionLogControl

sioc:has_container

n14:VOS

n16:has_services

n17:item

atom:title

VirtTipsAndTricksGuideTransactionLogControl

sioc:links_to

n4:TransactionAfterImageLimit n9:rdfperfsparul n10:ini_Parameters n4:VirtBulkRDFLoader n2:VirtTipsAndTricksGuide

atom:source

n14:VOS

atom:author

n8:this

atom:published

2017-06-13T05:47:39Z

atom:updated

2017-06-13T05:47:39Z

sioc:topic

n14:VOS