Re: Query performance with an ORDER BY

2022-02-10 Thread Andy Seaborne
Hi Andrew, On 09/02/2022 16:42, Andrii Berezovskyi wrote: Hello, We need to do paging in our app and as we don’t have a single property on which we can do a WHERE cutoff, we use an OFFSET/LIMIT. The OFFSET works fairly fast on the small values, however when we add an ORDER BY clause (as per

Query performance with an ORDER BY

2022-02-09 Thread Andrii Berezovskyi
Hello, We need to do paging in our app and as we don’t have a single property on which we can do a WHERE cutoff, we use an OFFSET/LIMIT. The OFFSET works fairly fast on the small values, however when we add an ORDER BY clause (as per SPARQL 1.1 spec as OFFSET is not guaranteed to make sense