Thanks ! It works very well now.
Best.
Julien.
2013/12/4 Rumi <rtsek...@openlinksw.com>
> 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 ?
>
>
> I suppose the value of the MaxSortedTopRows is not increased properly.
> Default is 10000.
> For example you can try with the following values:
>
> ;virtuoso.ini
>
> [Parameters]
> MaxSortedTopRows = 40000
> ...
>
> and maybe
>
> [SPARQL]
> ResultSetMaxRows = 50000
>
> Also, this example "*Using OFFSET and LIMIT" *at
> http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsparqlimplementationextentadvices
> 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> <http://fr.dbpedia.org>
> WHERE
> {
> ?a
> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type><http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
> <http://dbpedia.org/ontology/Place> <http://dbpedia.org/ontology/Place> .
> OPTIONAL {
> ?v0
> <http://dbpedia.org/ontology/wikiPageRedirects><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
> listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
------------------------------------------------------------------------------
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
