On 18 Sep 2006 at 7:26, andor gates wrote:

>What i d like to know is; each time it loops( or it SUSPENDS), does
>the row which returns from select statement travel on the network? or
>all rows are buffered in the db server or web server?

Rows are packed up to size TcpRemoteBufferSize (config param) and
then sent to client. Unless FOR UPDATE is specified in SELECT clause.

--
SY, Dimitry Sibiryakov.