[
https://issues.apache.org/jira/browse/GEODE-8287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17145049#comment-17145049
]
ASF GitHub Bot commented on GEODE-8287:
---------------------------------------
boglesby merged pull request #5279:
URL: https://github.com/apache/geode/pull/5279
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> QueryUtils doNestedIterationsForIndex is not applying an index value
> correctly and causing the entire region to be iterated
> ---------------------------------------------------------------------------------------------------------------------------
>
> Key: GEODE-8287
> URL: https://issues.apache.org/jira/browse/GEODE-8287
> Project: Geode
> Issue Type: Bug
> Components: querying
> Affects Versions: 1.12.0
> Reporter: Barrett Oglesby
> Assignee: Barrett Oglesby
> Priority: Major
> Labels: caching-applications
>
> Here is an example of the query in 8.2.12:
> {noformat}
> Query Executed in 3.502438E7 ms; indexesUsed(2):mapFieldIndex(Results:
> 500),pkIdIndex(Results: 1) "select vr1, vr2 from /region1 vr1, /region2 vr2
> where vr1.id = vr2.id and vr1.mapField['FIELDNAME']=$1"
> {noformat}
> The number of DistributionStats deserializations is 1,001.
> Here is an example of the query in 9.10.0:
> {noformat}
> Query Executed in 22732.467 ms; rowCount = 500;
> indexesUsed(2):mapFieldIndex(Results: 500),pkIdIndex(Results: 1) "select vr1,
> vr2 from /region1 vr1, /region2 vr2 where vr1.id = vr2.id and
> vr1.mapField['FIELDNAME']=$1"
> {noformat}
> The number of DistributionStats deserializations is 25,001,004
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
