FAQ
Would not it be better if we also had application-scoped statement fetch
size? After all, this is a way to decrease memory payload

2009/12/28 Andrus Adamchik (JIRA) <jira@apache.org>
SelectQuery 'fetchSize' setting is not propagated to disjoint prefetches
------------------------------------------------------------------------

Key: CAY-1349
URL: https://issues.apache.org/jira/browse/CAY-1349
Project: Cayenne
Issue Type: Bug
Components: Cayenne Core Library
Affects Versions: 3.0RC1
Reporter: Andrus Adamchik
Assignee: Andrus Adamchik
Priority: Minor
Fix For: 3.0RC2


When setting statementFetchSize property on select query with disjoint
prefetches, it only uses it for the root query, while this setting must be
copied to all the child prefetch queries.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

--
Andrey

Search Discussions

  • Andrus Adamchik at Dec 28, 2009 at 2:21 pm
    I've no idea what performance hit we'll take by enabling this setting.
    Looking at MySQL driver code I have a suspicion it may slow down
    smaller queries, as it switches to the "streaming mode" if the fetch
    size is enabled.. So one size may not fit all here. I'd say this needs
    to be researched more.

    Andrus

    On Dec 28, 2009, at 4:15 PM, Andrey Razumovsky wrote:

    Would not it be better if we also had application-scoped statement
    fetch
    size? After all, this is a way to decrease memory payload

    2009/12/28 Andrus Adamchik (JIRA) <jira@apache.org>
    SelectQuery 'fetchSize' setting is not propagated to disjoint
    prefetches
    ------------------------------------------------------------------------

    Key: CAY-1349
    URL: https://issues.apache.org/jira/browse/CAY-1349
    Project: Cayenne
    Issue Type: Bug
    Components: Cayenne Core Library
    Affects Versions: 3.0RC1
    Reporter: Andrus Adamchik
    Assignee: Andrus Adamchik
    Priority: Minor
    Fix For: 3.0RC2


    When setting statementFetchSize property on select query with
    disjoint
    prefetches, it only uses it for the root query, while this setting
    must be
    copied to all the child prefetch queries.

    --
    This message is automatically generated by JIRA.
    -
    You can reply to this email to add a comment to the issue online.

    --
    Andrey

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
categoriescayenne
postedDec 28, '09 at 2:16p
activeDec 28, '09 at 2:21p
posts2
users2
websitecayenne.apache.org

People

Translate

site design / logo © 2021 Grokbase