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) <jir..pache.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
This archive was generated by hypermail 2.0.0 : Mon Dec 28 2009 - 09:21:58 EST