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

From: stefcl (stefatwor..mail.com)
Date: Fri May 15 2009 - 10:21:36 EDT

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

    Thanks but my problem is not related to paging.

    I would like to be able to execute a select query which returns approx
    100000 rows with a single selectQuery and process them one by one, while
    keeping only a few of them in memory (using the resultiterator).

    In jdbc, Statement.setFetchSize(1000) tells the jdbc driver to retrieve
    results from the database 1000 at a time and ask for the next 1000 as you're
    iterating the resultset. Otherwise its default behavior is to retrieve the
    100'000 rows in memory before you can start iterating the resultset.

    It's not the same thing as inserting a TOP or a LIMIT clause in the query.

    Any help appreciated

    Andrey Razumovsky wrote:
    >
    > Hi,
    >
    > Yes of course. You can use SelectQuery.setFetchLimit(int) and
    > setFetchStart(int) methods. They do just that.
    >
    > Andrey
    > 

    -- 
View this message in context: http://www.nabble.com/Big-selects-on-PostGres-%3A-Configuring-Statement.setFetchSize%28%29-of-a-selectquery-tp23555842p23560831.html
Sent from the Cayenne - User mailing list archive at Nabble.com.

    This archive was generated by hypermail 2.0.0 : Fri May 15 2009 - 10:22:11 EDT