db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dyre.Tjeldv...@Sun.COM
Subject Re: Iterate over big table...
Date Mon, 12 Jun 2006 15:42:46 GMT
Suavi Ali Demir <demir4@yahoo.com> writes:

> if it is a forward only cursor, when you do a select * and loop through all rows and
doSomething() with each row (and not hold a reference to the data yourself), there would be
only 1 row's data in memory at a given time, no? (or few rows if Derby prefetches in chunks
as you do rs.next())

Could well be. I don't know :) I assumed that the OP had tried it and
WAS seeing out-of-memory errors when querying for all the
records.

-- 
dt

Mime
View raw message