Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Message-Id: <C370FE67-9C8F-4014-9E42-96C1A8244067@roxanemy.com>
From: Robert Zeigler <robert.zeigler@roxanemy.com>
To: user@cayenne.apache.org
In-Reply-To: <23560831.post@talk.nabble.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v935.3)
Subject: Re: Big selects on PostGres : Configuring Statement.setFetchSize() of
 a selectquery
Date: Fri, 15 May 2009 09:34:40 -0500
References: <23555842.post@talk.nabble.com>
 <3219fff70905150203m5b64fa23o1000be94502fc881@mail.gmail.com>
 <23560831.post@talk.nabble.com>

Take a look at paginated queries (which isn't /quite/ what you want,  
but may help you):

http://cayenne.apache.org/doc/paginated-queries.html

As well as ResultIterator:
http://cayenne.apache.org/doc/iterating-through-data-rows.html

Robert

On May 15, 2009, at 5/159:21 AM , stefcl wrote:

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