You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Andrus Adamchik (JIRA)" <ji...@apache.org> on 2009/12/28 15:09:29 UTC
[jira] Created: (CAY-1349) SelectQuery 'fetchSize' setting is not
propagated to disjoint prefetches
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.
Re: [jira] Created: (CAY-1349) SelectQuery 'fetchSize' setting is not propagated to disjoint prefetches
Posted by Andrus Adamchik <an...@objectstyle.org>.
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) <ji...@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
Re: [jira] Created: (CAY-1349) SelectQuery 'fetchSize' setting is not
propagated to disjoint prefetches
Posted by Andrey Razumovsky <ra...@gmail.com>.
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) <ji...@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
[jira] Closed: (CAY-1349) SelectQuery 'fetchSize' setting is not
propagated to disjoint prefetches
Posted by "Andrus Adamchik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAY-1349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrus Adamchik closed CAY-1349.
--------------------------------
Resolution: Fixed
> 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.