[jira] [Created] (CAY-2843) Use an IN clause for single field disjoint by ID prefetches

[Jurgen Doll (Jira)]

Jurgen Doll created CAY-2843:
--------------------------------

             Summary: 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


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)