Suavi Ali Demir <[EMAIL PROTECTED]> 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
