Jeffery,
On 8 Jul 2009, at 10:57, Jeffrey Pound wrote:
Hi,
On Mon, 6 Jul 2009, Ted Thibodeau Jr wrote:
You can analyze the results you're getting to see that the current
limit is 1000 rows per result set. You can work through this by
adding ORDER BY and LIMIT/OFFSET clauses to your query, and stepping
through the subsets --
SELECT ?name
WHERE
{
?a <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
<http://dbpedia.org/ontology/Actor> .
?a <http://www.w3.org/2000/01/rdf-schema#label>
?name
}
ORDER BY ?name
LIMIT 1000
OFFSET 1000 <-- 2000,3000,4000,...
You may wish to set the offset at multiples of 999, to get a
single-row
overlap between sets, which can then be used as a sanity check.
Note that the ORDER BY is *required* or you cannot be sure that the
results returned are coming in the same order every time, and thus
you cannot be sure that the OFFSET is skipping only already-returned
rows. (Just as with SQL...)
Unfortunately this solution will only work if the result size is
less than
40,000, since the endpoint does not allow sorting sets larger than
that.
Eventually you get an error like this (offset 40000, limit 100):
22023 Error SR353: Sorted TOP clause specifies more then 40100 rows to
sort. Only 40000 are allowed. Either decrease the offset and/or row
count
or use a scrollable cursor
[Hugh] 40000 is a restriction on the Dbpedia SPARQL endpoint which is
deemed to be a reasonable size for a result sets against the service
to protect it from inadvertent or other abuse. Thus your query will
need to be tailored to adhere to this restriction.
Best Regards
Hugh Williams
OpenLink Software
Are scrollable cursors implemented in the endpoint?
--
Jeff
Regards,
Ted
--
A: Yes. http://www.guckes.net/faq/
attribution.html
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?
Ted Thibodeau, Jr. // voice
+1-781-273-0900 x32
Evangelism & Support //
mailto:[email protected]
OpenLink Software, Inc. // http://
www.openlinksw.com/
http://www.openlinksw.com/weblogs/
uda/
OpenLink Blogs http://www.openlinksw.com/weblogs/
virtuoso/
http://www.openlinksw.com/blog/
~kidehen/
Universal Data Access and Virtual Database Technology Providers
---------------------------------------------------------------------
---------
_______________________________________________
Dbpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
----------------------------------------------------------------------
--------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited
time,
vendors submitting new applications to BlackBerry App World(TM)
will have
the opportunity to enter the BlackBerry Developer Challenge. See
full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Dbpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Dbpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
