Subject Re: [firebird-support] Select Statement -> Dataset
Author Ann W. Harrison
lec_sas wrote:
> ... to get the
> data, you have to use the fetch statement which returns 1 record at a
> time, this doesnt seem like it could potentially be a good way to get
> the data to the grid.

For what it's worth, unless you use "select ... for update"
the remote interface creates a packet of rows for transfer
to the client. The client side then removes rows from the
packet one at a time, giving the appearance of returning one
row at a time, but better network performance.