> When using either interface, I notice that when I select rows from a
> table, it appears that the client interface retrieves the entire
> results set at once...and loads it into memory on the client machine.
The standard answer is to use a cursor and FETCH a few rows at a time.
> Do you folks publish the network symantics and protocols used to
> make sql requests and retrieve their results?
regards, tom lane
In response to
pgsql-interfaces by date
|Next:||From: Ryan Mooney||Date: 2003-08-19 22:17:08|
|Subject: ECPG Connect user :variable problem|
|Previous:||From: Peter.Rupp||Date: 2003-08-18 14:44:11|
|Subject: Help with retrieving large results sets and memory usage.|