Re: [Virtuoso-users] Implicit ordering

2014-04-23 Thread Hugh Williams
Hi Štěpán For a stable/consistent pagination, an ORDER BY is always necessary. Even if the data is constant and the statistics of indexes are not refreshed between fetching different pages, the optimizer can chose different ordering depending on number of rows to skip and return. In fact no ORD

[Virtuoso-users] Implicit ordering

2014-04-23 Thread Bc . Štěpán Pilař
Hi, I'm working with Silk to find links within a dataset. I have several graphs, each with tens of thousands of resources for linking in a Virtuoso instance. When given Virtuoso SPARQL endpoint parameters to Silk it is able to load in batches (default by 1000) all resources needed, even though