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

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Sun May 17 2009 - 08:12:28 EDT

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

    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.
    >
    >



    This archive was generated by hypermail 2.0.0 : Sun May 17 2009 - 08:13:03 EDT