On 23 May 2009, at 17:41, Mirko wrote:
Hi all, I have an understanding problem with paging (limit/offet) in Sparql.Consider the following query: Select ?userID ?itemID ?date WHERE { ?user my:hasUserID ?userID .. ?user my:owns ?item .. ?item my:hasItemID ?itemID .. ?item my:soldToUser ?date .. FILTER (?date > 20090101) } ORDER BY ?userID LIMIT 1000 OFFSET 0 A user might own multiple items.The results are to large to keep in memory, so I would like to page them using LIMIT and OFFSET. However it does not work with the above query. The query above needs all results to be loaded into memory when evaluating it. I assume this is because more than one statement is evaluated in the WHERE clause(?).
It should work in theory, I think this is a question for whoever wrote your RDF store.
- Steve
