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

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

PrefixNamespace IRI
dctermshttp://purl.org/dc/terms/
atomhttp://atomowl.org/ontologies/atomrdf#
foafhttp://xmlns.com/foaf/0.1/
n14http://vos.openlinksw.com/dataspace/services/wiki/
oplhttp://www.openlinksw.com/schema/attribution#
n2http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
n12http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtTipsAndTricksHowToHandleBandwidthLimitExceed/sioc.
dchttp://purl.org/dc/elements/1.1/
n10http://vos.openlinksw.com/dataspace/dav#
rdfshttp://www.w3.org/2000/01/rdf-schema#
n15http://rdfs.org/sioc/services#
siocthttp://rdfs.org/sioc/types#
n7http://vos.openlinksw.com/dataspace/person/dav#
n5http://vos.openlinksw.com/dataspace/owiki/wiki/
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n4http://vos.openlinksw.com/dataspace/owiki#
xsdhhttp://www.w3.org/2001/XMLSchema#
n13http://vos.openlinksw.com/dataspace/person/owiki#
siochttp://rdfs.org/sioc/ns#
Subject Item
n7:this
foaf:made
n2:VirtTipsAndTricksHowToHandleBandwidthLimitExceed
Subject Item
n10:this
sioc:creator_of
n2:VirtTipsAndTricksHowToHandleBandwidthLimitExceed
Subject Item
n14:item
n15:services_of
n2:VirtTipsAndTricksHowToHandleBandwidthLimitExceed
Subject Item
n4:this
sioc:creator_of
n2:VirtTipsAndTricksHowToHandleBandwidthLimitExceed
Subject Item
n5:VOS
sioc:container_of
n2:VirtTipsAndTricksHowToHandleBandwidthLimitExceed
atom:entry
n2:VirtTipsAndTricksHowToHandleBandwidthLimitExceed
atom:contains
n2:VirtTipsAndTricksHowToHandleBandwidthLimitExceed
Subject Item
n2:VirtTipsAndTricksHowToHandleBandwidthLimitExceed
rdf:type
atom:Entry sioct:Comment
dcterms:created
2017-06-13T05:42:22.147930
dcterms:modified
2017-06-13T05:42:22.147930
rdfs:label
VirtTipsAndTricksHowToHandleBandwidthLimitExceed
foaf:maker
n7:this n13:this
dc:title
VirtTipsAndTricksHowToHandleBandwidthLimitExceed
opl:isDescribedUsing
n12:rdf
sioc:has_creator
n4:this n10:this
sioc:content
%META:TOPICPARENT{name="VirtTipsAndTricksGuide"}% ---+ Working with SPARQL endpoint constraints via LIMIT & OFFSET The DBpedia SPARQL endpoint is configured with the following Virtuoso INI setting: <verbatim> MaxSortedTopRows = 40000 </verbatim> This setting sets a threshold on sorted rows. SPARQL queries that include OFFSET and LIMIT will feel the effect of the hard limit set in the INI. For instance, this query -- <verbatim> DEFINE sql:big-data-const 0 SELECT DISTINCT ?p ?s FROM <http://dbpedia.org> WHERE { ?s ?p <http://dbpedia.org/resource/Germany> } ORDER BY ASC(?p) OFFSET 40000 LIMIT 1000 </verbatim> -- will return the following error on execution -- <verbatim> HttpException: 500 SPARQL Request Failed Virtuoso 22023 Error SR353: Sorted TOP clause specifies more then 41000 rows to sort. Only 40000 are allowed. Either decrease the offset and/or row count or use a scrollable cursor </verbatim> To prevent this error, you can leverage the use of subqueries which make better use of temporary storage. For example -- <verbatim> SELECT ?p ?s WHERE { { SELECT DISTINCT ?p ?s FROM <http://dbpedia.org> WHERE { ?s ?p <http://dbpedia.org/resource/Germany> } ORDER BY ASC(?p) } } OFFSET 50000 LIMIT 1000 </verbatim> ---++Related * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]]
sioc:id
7bafd2eb5014682acb007774c69ef9d6
sioc:link
n2:VirtTipsAndTricksHowToHandleBandwidthLimitExceed
sioc:has_container
n5:VOS
n15:has_services
n14:item
atom:title
VirtTipsAndTricksHowToHandleBandwidthLimitExceed
atom:source
n5:VOS
atom:author
n7:this
atom:published
2017-06-13T05:42:22Z
atom:updated
2017-06-13T05:42:22Z
sioc:topic
n5:VOS