[jira] [Updated] (CAY-1700) Split long DISJOINT_BY_ID prefetch query on several smaller queries

["Andrei Veprev (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CAY-1700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrei Veprev updated CAY-1700:
-------------------------------

    Attachment: CAY-1700.patch

Patch:
* implemented split of queries
* using special property to define max number of qualifiers per query
* changed IncrementalFaultList to use the same property

Consider to change javadoc for property if it isn't written good.
                
> Split long DISJOINT_BY_ID prefetch query on several smaller queries
> -------------------------------------------------------------------
>
>                 Key: CAY-1700
>                 URL: https://issues.apache.org/jira/browse/CAY-1700
>             Project: Cayenne
>          Issue Type: Improvement
>          Components: Core Library
>    Affects Versions: 3.1M4
>            Reporter: Andrei Veprev
>             Fix For: 3.1M4
>
>         Attachments: CAY-1700.patch
>
>
> It is improvement for CAY-1681. From Andrus' comment:
> And one more thing we will probably have to implement - breaking down OR query if it gets too long. This is a real problem which has been repeatedly mentioned in the context of the paginated queries, and in fact solved in IncrementalFaultList. see IncrementalFaultList.resolveInterval - it checks the number of clauses in the qualifier against 'maxFetchSize'. We may need to make "maxFetchSize" a container property used by IncrementalFaultList as well as our prefetch strategy, and take it into account in the later.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira