I know that I’ve asked this question before, but I am still struggling to understand how I might handle this case:
I have a Jena DB of event entries. One common way to view the events is to page through them. Normally this is done by seeing the most recent 50 events and then paging to the next 50 most recent and so on. In pure SPARQL, I don’t really see an efficient way to accomplish this. With limit and offset, I don’t really save anything other than i/o since the whole result set will need to be ordered before this limit/offset has an effect. And that is killing us now. My guess is we will need to implement some caching or possibly index the graph with Lucene or something. It is doable but definitely not ideal. Maybe I can use the quad position to facilitate this? I am assuming this cannot be optimized within Jena itself? Best, Adam
