Thanks for the Jira. Can't give you a time estimate on that, we are an
open source project after all. All I can say now is that adding this
API to Cayenne is fairly trivial (you can even take a shot at this
yourself, if you feel like hacking the Cayenne internals). But before
we commit anything like that, I'd like us to research the effects of
this on at least a few of the databases that Cayenne supports, and
various driver-specific caveats that I am sure will arise. So this
will take some time to make it a production quality feature.
Andrus
On May 17, 2009, at 12:52 PM, stefcl wrote:
According to the JDBC javadoc, setFetchSize(int) is an *hint* you
can give,
the driver may decide to ignore it. Nevetheless I'm sure it's useful
because
other OR/mapper like IBatis provide a way to set this parameter.
I have filled a Jira issue about this :
https://issues.apache.org/jira/browse/CAY-1225
https://issues.apache.org/jira/browse/CAY-1225
I really hope there's a chance to get a fix shortly, because Cayenne
is the
only OR/mapper that gave me satisfaction.
Andrus Adamchik wrote:
I haven't experimented with that much (so no idea which drivers take
advantage of that and which would simply ignore it), but that would
indeed be a useful parameter for ResultIterator scenario. So maybe
open a feature request in Jira?
Andrus
--
View this message in context:
http://www.nabble.com/Big-selects-on-PostGres-%3A-Configuring-Statement.setFetchSize%28%29-of-a-selectquery-tp23555842p23581761.html
Sent from the Cayenne - User mailing list archive at Nabble.com.
