LIMIT problem (Paging)

• From: Mirko <idonthaveenoughinformation@googlemail.com>
• Date: Sat, 23 May 2009 18:41:23 +0200
• To: public-sparql-dev@w3.org
• Message-Id: <753BDD56-FF1D-45F1-805D-4B997FC4EA47@googlemail.com>

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(?).

So, how could I page the above query?

Thanks, Mirko

Received on Monday, 25 May 2009 06:18:49 UTC