Stefan Egli created OAK-1263:
--------------------------------
Summary: optimize oak index to support 'fast ORDER BY' queries to
support sorting & pagination for large set of children
Key: OAK-1263
URL: https://issues.apache.org/jira/browse/OAK-1263
Project: Jackrabbit Oak
Issue Type: Improvement
Components: query
Affects Versions: 0.12
Reporter: Stefan Egli
We have a use case where we'd like to be able to use an index in a
"pagination-like" fashion. That is, we'd like to be able to have an index on a
subtree on a certain property, and then run a query which does ORDER BY that
property combined with OFFSET. That way, essentially allowing pagination of
child nodes of a particular parent based on 'sorted by a certain property'.
AFAIU currently the oak index is not optimized to support ORDER BY queries in a
fast manner. The index keeps 'the child nodes unsorted', ie to process an ORDER
BY, the child nodes would have to be 'manually sorted' which can result in bad
performance given a large number of child nodes.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
