Peter,
Postgres will return the entire result into memory first before
processing the first row of data. If you don't want this behavior you
should use explicit cursors and fetch statements to get data a few rows
at a time. See the postgres documentation on the 'cursor' and 'fetch'
sql statements.
thanks,
--Barry
Peter Wasem wrote:
> Hi
>
> I have a problem in processing large numbers of rows in ResultSets.
> Here's the code fragment where the problem occurs:
>
> ...
> ResultSet rset = stmt.executeQuery( "select ... from ... where ...
> order by ..." ) ;
> while(rset.next() )
> { // Process the row }
> ...
>
> The query addresses some 100'000 rows. When stmt.executeQuery() is
> executed suddenly an exception occurs.
> The same program works fine with other JDBC drivers.
>
> Any ideas ?
>
> Greetings
> Peter
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>