cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: [jira] Created: (CAY-1349) SelectQuery 'fetchSize' setting is not propagated to disjoint prefetches
Date Mon, 28 Dec 2009 14:21:22 GMT
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


Mime
View raw message