Re: LIMIT problem (Paging)

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