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
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
