Amit Jain created OAK-2618:
------------------------------
Summary: Improve performance of queries with ORDER BY and multiple
OR filters
Key: OAK-2618
URL: https://issues.apache.org/jira/browse/OAK-2618
Project: Jackrabbit Oak
Issue Type: Improvement
Components: query
Reporter: Amit Jain
Fix For: 1.4
When multiple OR constraints are specified in the XPATH query, itis broken up
into union of multiple clauses. If query includes an order by clause, the
sorting in this case is done by traversing the result set in memory leading to
slow query performance.
Possible improvements could include:
* For indexes which can support multiple filters (like lucene, solr) such
queries should be efficient and the query engine can pass-thru the query as is.
** Possibly also needed for other cases also. So, we can have some sort of
capability advertiser for indexes which can hint the query engine
and/or
* Batched merging of the sorted iterators returned for the multiple union
queries (possible externally).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
