[
https://issues.apache.org/jira/browse/CAY-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nikita Timofeev closed CAY-2843.
--------------------------------
Resolution: Fixed
> 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
> Assignee: Nikita Timofeev
> Priority: Minor
> Labels: pull-request-available
> Fix For: 5.0-M1
>
> Time Spent: 0.5h
> 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)
