Re: [Virtuoso-users] Issue with ResultSetMaxRows property

[Rumi]

Hi Julien,


On 04-Dec-13 1:11 PM, Julien Plu wrote:

Hi,

When I try to make a query on my SPARQL endpoint I have this error :

Virtuoso 22023 Error SR353: Sorted TOP clause specifies more then 11000 rows to 
sort. Only 10000 are allowed. Either decrease the offset and/or row count or 
use a scrollable cursor
Whereas my ResultSetMaxRows property is setted to "100000".

The query is :

SELECT ?a ?v0
FROM <http://fr.dbpedia.org>
WHERE {

?a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://dbpedia.org/ontology/Place> .

OPTIONAL {
?v0 <http://dbpedia.org/ontology/wikiPageRedirects> ?a .
}
} ORDER BY ?a OFFSET 10000 LIMIT 1000

And my Virtuoso version is 07.00.3207.

How I can solve this issue ?

For example you can try with the following values:

;virtuoso.ini

[Parameters]
MaxSortedTopRows = 40000
...

and maybe

[SPARQL]
ResultSetMaxRows = 50000

I suppose the value of the MaxSortedTopRows is not increased properly. Default is 10000. Also, this example "*Using OFFSET and LIMIT" *at http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsparqlimplementationextent advices in situations like yours ( getting the same error ), to prevent the problem, you can leverage the use of sub-queries which make better use of temporary storage associated with this kind of quest.

i.e. your query would look like:

SELECT ?a ?v0
WHERE
  {
    { SELECT ?a ?v0
      FROM <http://fr.dbpedia.org>
      WHERE
        {

?a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://dbpedia.org/ontology/Place> .

          OPTIONAL {
             ?v0 <http://dbpedia.org/ontology/wikiPageRedirects> ?a .
          }
        }
      ORDER BY ?a
    }
  }
OFFSET 10000 LIMIT 1000

Result set against dbpedia.org:  http://bit.ly/1ayCs7c


Hope this helps.

Best Regards,
Rumi Kocis

Thanks in advance.

Julien.


------------------------------------------------------------------------------
Sponsored by Intel(R) XDK
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk


_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

smime.p7s
Description: S/MIME Cryptographic Signature

------------------------------------------------------------------------------
Sponsored by Intel(R) XDK 
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users