[
https://issues.apache.org/jira/browse/PHOENIX-6752?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17574413#comment-17574413
]
ASF GitHub Bot commented on PHOENIX-6752:
-----------------------------------------
gjacoby126 commented on PR #1469:
URL: https://github.com/apache/phoenix/pull/1469#issuecomment-1203265073
@jpisaac - the new test in InListIT was causing OOMs during the iteration
where it ran with 50,000 ORs (both in CI and locally). I tweaked it so it runs
with at most 5000 ORs, and now it passes for me locally. If 50,000 ORs needs to
be supported, either the test heap size needs to be bigger, or we need further
optimization.
> Duplicate expression nodes in extract nodes during WHERE compilation phase
> leads to poor performance.
> -----------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-6752
> URL: https://issues.apache.org/jira/browse/PHOENIX-6752
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.15.0, 5.1.0, 4.16.1, 5.2.0
> Reporter: Jacob Isaac
> Assignee: Jacob Isaac
> Priority: Major
> Attachments: test-case.txt
>
>
> SQL queries using the OR operator were taking a long time during the WHERE
> clause compilation phase when a large number of OR clauses (~50k) are used.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
