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) <[email protected]>
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
