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.
