[
https://issues.apache.org/jira/browse/OAK-2618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Marth updated OAK-2618:
-------------------------------
Fix Version/s: (was: 1.3.5)
1.3.7
> 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
> Assignee: Amit Jain
> Labels: performance
> Fix For: 1.3.7
>
>
> 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)
