[
https://issues.apache.org/jira/browse/CAY-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17815333#comment-17815333
]
Jurgen Doll commented on CAY-2843:
----------------------------------
Created a [PR|https://github.com/apache/cayenne/pull/606] containing a
potential solution that passes the tests.
> Use an IN clause for single field disjoint by ID prefetches
> -----------------------------------------------------------
>
> Key: CAY-2843
> URL: https://issues.apache.org/jira/browse/CAY-2843
> Project: Cayenne
> Issue Type: Improvement
> Components: Core Library
> Affects Versions: 4.2
> Reporter: Jurgen Doll
> Priority: Minor
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Currently HierarchicalObjectResolver uses "field1 = ? OR field1 = ? ...."
> pattern for all disjoint by ID prefetches.
> I propose distinguishing between single field prefetches and multi-field
> prefetches, so that the former makes use of an IN clause instead.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
