On Oct 27, 2006, at 5:29 AM, Stefano B. wrote:
I have investigate about the possibility of load (in the client side) only a small subset of the resultset but with no luck. In the maling lists I see that the only way to load the resultset incrementally is to define a forward only resultset with autocommit off, and using setFetchSize(...). But this solution doesn't solve my problem because if the user scrolls the entire table, the whole resultset will be downloaded...
I don't use JDBC so maybe I don't understand the limitations. But PostgreSQL supports cursors that can be scanned forward and backwards. Using FETCH you can just get the data you need for the display. See the DECLARE documentation:
http://www.postgresql.org/docs/8.1/interactive/sql-declare.html John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
