[JBoss JIRA] Resolved: (TEIID-238) ENHANCEMENT: performance of non-pushed dependent set criteria
- First Post
- Replies
- Stats
-
Go to
- ----- 2024 -----
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://jira.jboss.org/jira/browse/TEIID-238?page=com.atlassian.jira.plug...
]
Steven Hawkins resolved TEIID-238.
----------------------------------
Resolution: Done
Added a check of the dependent value side - if it is less than 1/2 a batch then we'll
materialize the values as a cached hashset, otherwise we'll simply return true and
rely on the partitioned join logic to kick in if applicable.
ENHANCEMENT: performance of non-pushed dependent set criteria
-------------------------------------------------------------
Key: TEIID-238
URL: https://jira.jboss.org/jira/browse/TEIID-238
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 6.0.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 6.1.0
Original Estimate: 1 day
Remaining Estimate: 1 day
Defect Tracker #24299: Dependent set criteria that is not pushed below an access node has
potentially bad performance implications. These nodes should either be removed or the
evaluation of set criteria should be changed so that it does not need to be based upon
iteration (such as a cached set of values).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5507
days inactive
5507
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)