Re: Big selects on PostGres : Configuring Statement.setFetchSize() of a selectquery

From: stefcl (stefatwor..mail.com)
Date: Sun May 17 2009 - 05:52:54 EDT

  • Next message: Andrus Adamchik: "Re: Big selects on PostGres : Configuring Statement.setFetchSize() of a selectquery"

    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.

    This archive was generated by hypermail 2.0.0 : Sun May 17 2009 - 05:53:31 EDT