Great thanks Fred
From: Frederick Giasson [mailto:f...@fgiasson.com]
Sent: Friday, February 06, 2015 1:52 PM
To: virtuoso-users@lists.sourceforge.net
Subject: Re: [Virtuoso-users] virtuoso Sorted TOP clause specifies more then
1000000 rows
Hi Phillip
Virtuoso 22023 Error SR353: Sorted TOP clause specifies more then 1000000 rows
to sort. Only 10000 are allowed. Either decrease the offset and/or row count or
use a scrollable cursor
Yes, you have to use subqueries for that. Instead of writing:
select ?s ?pref
from <http://dbpedia.org><http://dbpedia.org>
where
{
?s
<http://www.w3.org/2000/01/rdf-schema#label><http://www.w3.org/2000/01/rdf-schema#label>
?pref .
}
order by asc(?pref)
limit 100
offset 20000
Do use a subquery like this:
select ?s ?pref
from <http://dbpedia.org><http://dbpedia.org>
where
{
{
select ?s ?pref
{
?s
<http://www.w3.org/2000/01/rdf-schema#label><http://www.w3.org/2000/01/rdf-schema#label>
?pref .
}
order by asc(?pref)
}
}
limit 100
offset 20000
Thanks,
Fred
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
